Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try your code in the HTML/ASP part of the webpage
The table structure is Month Headline Image Caption Content I can have many entries with the same month. Distinct makes a page with Click here for "MONTH" news. Clicking on "MONTH" takes you to all entries with that "MONTH" Currently the page that displays Click here for "MONTH" news is not in calendar order. Click here for "MONTH" Click here for "MONTH" ----- Original Message ----- From: Gurhan Ozen <[EMAIL PROTECTED]> To: Peter Sampson <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 10:14 PM Subject: RE: Simple SQL > 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
