php and mysql
| From: | Tyler Durdin | Date: | Mon, 31 Mar 2003 18:53:11 +0000 |
| Subject: | php and mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-141719@lists.php.net to get a copy of this message | ||
I have a db with events in it. i would like to pull the events out via php, but i would like them to be ordered by month number (1-12). When I do this (Select blah blah From blah Order By Month_Start ASC) it orders the months by number, but it starts with october (month 10) I am pretty sure it is doing this because I have no events until april (month 4). So how can i get it to order the months by their numbers starting with january (1) and going to december (12) even if I do not have events until april (4)?
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail