Re: php and mysql

yah you're right on. The column is varchar. I will change it. Thanks for the insight.

From: Jimmy Brake <jimmy@dwalliance.com> To: Tyler Durdin <linuxgeek23@hotmail.com> CC: php-general@lists.php.net Subject: Re: [PHP] php and mysql Date: 31 Mar 2003 10:49:30 -0800 is the column that you are selecting the dates from a date column? sounds like you may be storing your dates in a varchar or some other type of general text column On Mon, 2003-03-31 at 10:53, Tyler Durdin wrote: 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

_________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail