Honestly, I'd store the month as an integer (1-12) and handle the conversion to a text month in the PHP/output step instead. But, if you absolutely MUST keep text month names, you can employ the ORDER BY FIELD approach which would look something like this:
Originally Posted by holy24
That won't be as fast or efficient (or nearly as flexible) as a standard ORDER BY month ASC/DESC type of query but it will work.
mysql_query ("SELECT * FROM Table1 WHERE year='$Year' ORDER BY FIELD (month, 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December')"; ?>