List:General Discussion« Previous MessageNext Message »
From:Gurhan Ozen Date:May 15 2002 9:14pm
Subject:RE: Simple SQL
View as plain text  
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:frontpages@stripped]
Sent: Wednesday, May 15, 2002 3:06 PM
To: mysql@stripped
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 <mysql-thread109148@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-c-gurhan.ozen=wcom.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
DBI connect (help)Taylor Lewick15 May
  • Simple SQLPeter Sampson15 May
    • RE: Simple SQLGurhan Ozen15 May
      • Re: Simple SQLPeter Sampson15 May
        • RE: Simple SQLRoger Baklund16 May
      • Re: Simple SQLPeter Sampson15 May
  • Re: Simple SQLRodney Broom15 May
    • RE: Simple SQLRoger Baklund15 May
  • Re: Simple SQLMark15 May