Using php to order...

[Mekhu]

What I want to do is call a bunch of info from a dbase and have it ordered to the way I want it.

Here is what I have so far:

$Query = "SELECT country,destination,resort,start_date,end_date,price,nights, kid_club,honeymoon,allinc,picture,copy,id FROM vacation ORDER BY country,destination,resort,start_date,nights;";

This portion of the above code (ORDER BY country,destination,resort,start_date,nights;";) seems to work fine until I hit the "start_date". Since it includes both letters and numbers I don't have it as an int field. This means that it's ordering by alpha order... Any way I can make it order by actual month and number?

Thanks,

Mekhu