Posted by kenoli on 11/14/05 20:08

I am querying a mysql database and using ORDER BY in my query statement
to order the results on a date field.

It seems to be handling the day and year part OK, but when it orders
the month part it is ordering by the first digit first, thus "10" is
seem as "1" like this:

10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9

Is there some way I can tell it to order the months like this:

1,2,3,4,5,6,7,8,9,10,11,12

In this case,

Thanks,

--Kenoli

• Next in forum: Re: ORDER BY order of months
• Prev in forum: is php something that apache interprets?
• Thread view: ORDER BY order of months

[Reply to this message]