Can anyone help with my problem below?

[StuA]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10233794

Pleaseeeeeee!! 🙂

[girishn]

Hi,

You can sort the day,month,year in the SQL itself(as you told that there are three fields)
select * from table ORDER BY day,month,year
....Read more about ORDER BY in the manual

And presently I don;t think these lines are required there, Life will go on still if you delete these lines 🙂

$start_year = array ('2003', '2004', '2005', '2006', '2007', '2008', '2009', '2010', '2011', '2012');
$start_month = array ('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');
$start_day = array ('1st', '2nd', '3rd', '4th', '5th', '6th', '7th', '8th', '9th', '10th', '11th', '12th', '13th', '14th', '15th', '16th', '17th', '18th', '19th', '20th', '21st', '22nd', '23rd', '24th', '25th', '26th', '27th', '28th', '29th', '30th', '31st');
array_multisort ($start_year[0], $start_month[1], $start_day[2]);

Cheers,
Girish

[StuA]

...now I can sort by year, then month, then day...how do I sort the months in order as they appear on the calendar rather than alpahbetically as they are now:

http://www.net-strategy.co.uk/ainscough_training/course_dates.php

[girishn]

Hi,

Quite a bad situation with you!!

You know a book on a topic is best if you are new in any field 🙂

I don't have one, so please check if there is some direct method to get month in Number from Text.

I suggest you to keep the dates in one field,

currently you can try this ugly SQL

SELECT *, DATE_FORMAT("your date","%Y-%m-%d") as some_date ORDER BY some_date

🙂