Posted by Peter van Schie on 09/26/06 22:36

aquanutz@gmail.com schreef:
> My sql query will not seem to bring back dates in the correct order. It
> will brin them back in a semi-order. Here is the query and what it
> brings back. Any thoughts on how to get the dates to come back in
> order, formatted the way I want? Thanks.

Hi Aquanutz,

Your query does exactly what you ask it to. I.e. it sorts your results
by your aliased formatted dates, hence you first get september (starting
with an 's') then october (starting with an 'o') etc.
I assume you want to sort by date (i.e. the original startdate in date
format), so you should just rename your aliases startDate and endDate
into something else and then sort by startDate and endDate (the original
columns).

HTH.
Peter.
--
http://www.phpforums.nl

[Back to original message]