mySQL sort date trouble

hi all,

i have a mysql db with a datetime field formatted as such:

datetime yyyy-mm-dd 00:00:00

and my sql query looks like such:

$anyday = mktime (0,0,0,date("m") ,date("d"), date("Y"));
$valueOfAnyDay = date("M d, Y",$anyday);

SELECT *,date_format(eventDate, '%M %d, %Y') as eventDate FROM tbl_events where eventDate >= '".$valueOfAnyDay."' order by eventDate

HOWEVER, the sort is all weird:

it lists it as such:

July 3
July 20
June 12
May 27

when it should be listing as:

May 27
June 12
July 3
July 20

i notice that when I take out the date_format(...) piece of code, it sorts correctly.

any suggestions?

SELECT *,date_format(eventDate, '%M %d, %Y') as eventDate FROM tbl_events where eventDate >= '".$valueOfAnyDay."' order by eventDate DESC

Hope this helps,

Brad

thanks, i tried the order by eventDate DESC, and this is what i got

May 27
Jun 12
Jul 20 <---- ??????
Jul 03

so, you can see that order by desc is not working here.

what kind of column is the date stored in? and did you get Jul 03 or Jul 3?

Brad

*edit - I see by your first post it is datetime.

datetime yyyy-mm-dd 00:00:00

well, if it works correctly with the date_format(...) removed, could you format the date after it is selected?

$outputDate = date("M, d", $eventDate);

Brad