php and mysql

From: 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

« previous php.general (#141719) next »