Order By

I current have this in my mysql statement

date_format(date, '%m/%d/%Y') as date FROM members order by date DESC

but since the new year it places all 2013 items at the end of the query.

any help would be great how I can get it to show the 2013 stuff ahead of the 2012 and etc..

Thanks


Slayer.

You have aliased back to the original property name, so you are now doing string comparisons, not date comparisons. Either don't alias back to date giving it a different name, or order by members.date. Either should work.

Hai...
Check this coding ...
It's worked properly...
SELECT post(datefield as date) AS date_format ORDER BY date_format DESC

Hai...
Check this coding ...
It's worked properly...
SELECT post(datefield as date) AS date_format ORDER BY date_format DESC

*** WRONG ANSWER ***

There is no such function as POST( ) in MySQL.

And in any case, the answer is irrelevant to the question asked.