order by date in mysql query

[Alx]

ok questions.

i am sorting a type 'date' in my database, which is evidently a date inserted as now()

but when i try things like 'ORDER BY mix_date DESC' the results are NOT properly ordered by date. whats up with that!???

[joelstobart]

I haven't had a problem with this before.

in the select you arent rewriting the column for output e.g.


date_format(mix_date, '%m/%e/%Y') as mix_date

if you are rename the output column, and order by the data column

could you send me your whole query? so that I can cast an eye over it?

- Joel