Peter, Please give us more insight on this. Is the column where you store dates (or months) is a date datatype column?? If yes you can just do
SELECT ... FROM table_name ORDER BY MONTH(column_name); It'll help to see your table structure to help you. Thanks. Gurhan -----Original Message----- From: Peter Sampson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: Simple SQL SQL beginner using Macromedia Ultradev. Can you help? Please be gentle I'm not a programmer! I am using Select DISTINCT Month FROM tblNews The problem is that the months are shown alphabetical not in calendar order. How can I change this? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
