Posted by gerg on 10/07/04 11:35

In my database I've got calendar table with the following fields,
`month`, `day`,`year`.

My sql query is

$sql="SELECT * FROM `calendar` ORDER BY `year`,`month`,`day` ASC";

This query puts the oldest "years" at the top, IE 2005 at the top 2007
at the bottom, but then it alphabatizes the month. Is there any way to
get the query to order them in the actual month order, IE don't put
April above February during an ordering. The months are input into the
database with the full month name IE March or December.

Thanks in advance!

Greg

[Back to original message]