date ORDER BY

Hi,

I'm currently running a sql select statement on a date field which is
ordered by the date field in ascending order. It worked fine for the 1st to
the 9th of the month but when it output 10th, 11th, 12th etc. it put them
before the 1st. So I was getting:

10th
11th
12th
1st
2nd
.....

my query is:

$totalquery = "SELECT click, search, shop, DATE_FORMAT(date, '%D %b, %Y') AS
date FROM donation_totals ORDER BY date ASC LIMIT 7"

Any ideas why this is happening?

Thanks,

Adi

On Mon, 14 Jul 2003 09:19:09 +0100, Adi <admin RemoveThis @NOSPAMadigaskell.org> wrote:

 > Hi,
 >
 > I'm currently running a sql select statement on a date field which is
 > ordered by the date field in ascending order. It worked fine for the 1st
 > to
 > the 9th of the month but when it output 10th, 11th, 12th etc. it put them
 > before the 1st. So I was getting:
 >
 > 10th
 > 11th
 > 12th
 > 1st
 > 2nd
 > ....
 >
 > my query is:
 >
 > $totalquery = "SELECT click, search, shop, DATE_FORMAT(date, '%D %b, %Y')
 > AS
 > date FROM donation_totals ORDER BY date ASC LIMIT 7"
 >
 > Any ideas why this is happening?

Try:

$totalquery = "SELECT click, search, shop, DATE_FORMAT(date, '%D %b, %Y')
AS date FROM donation_totals ORDER BY CAST(date AS UNSIGNED) ASC LIMIT 7"

* not tested.

Grey

--
The technical axiom that nothing is impossible sinisterly implies the
pitfall corollory that nothing is ridiculous.
- <a style='text-decoration: underline;' href="http://www.greywyvern.com" target="_blank">http://www.greywyvern.com</a> - Orca RingMaker: PHP web ring creation and
management<!-- ~MESSAGE_AFTER~ -->