using MONTH() with integer date

[scarhand]

`the_date` is an integer whose value is inserted via the php time() function

 

this code doesn't seem to work, so I imagine I am missing a function:

 

$sql = 'SELECT SUM(`amount`) as donate_total from `donations` where MONTH(`the_date`) = MONTH(CURDATE())';

 

any help would be great.

[Pikachu2000]

I assume you mean the value in the database is a UNIX timestamp?

 

$sql = 'SELECT SUM(`amount`) as donate_total from `donations` where MONTH(FROM_UNIXTIME(`the_date`)) = MONTH(CURDATE())';

[scarhand]

you rock