[SOLVED] where date_format(postdate, '%M %Y')='$month $year'

[scarhand]

This is not working:

 

(the postdate field stores a time integer via the php time() function)

 

$month = 'July';
$year = '2009';

$sql = mysql_query("select * from rss where date_format(postdate, '%M %Y')='$month $year' order by postdate desc");

[PFMaBiSmAd]

DATE_FORMAT() operates on a DATE or DATETIME data type.

 

Try the FROM_UNIXTIME(unix_timestamp,format) function with the second parameter set to '%M %Y'

[scarhand]

Thanks. Figured it was something like that.