help: problems with order by.

[Anon]

I`m having problems with this query:
$query = "select DATE_FORMAT(recdat,'%d-%m-%Y') as recdat,recime,recid,recimg,recv,recub,recav,rautor,recav from recenzija order by recdat desc"

The problem is that order by recdat (which is formated date field) doesn`t work, is the problem in date_format or something else?

[Anon]

if two data are entered at the same date then your problem arise isn't?

[[deleted]]

Q: do you get an error or does it just not do what you want?

[Anon]

I don`t get an error, queu works, but result is not sorted by date in descending order.

[[deleted]]

That is because you are ordering by a formatted date:

DATE_FORMAT(recdat,'%d-%m-%Y')

the format is day-month-year, so 02-01-2001
will come before 03-07-2000.

Try ordering by the original recdat:

select DATE_FORMAT(recdat,'%d-%m-%Y') as recdatstring, recime, recid, recimg, recv, recub, recav, rautor, recav
from recenzija order by recdat