ORDER BY problem

[Anon]

Hi Folks!

I've have a problem with the mysql order by clause.
What i want to do is ordering a table by name (asc) and date (desc), but it isn't possible by doing: ORDER BY name ASC date DESC

Can anyone help me please?!

Greetz,
Daniel

[Anon]

ORDER BY name ASC, date DESC

that should fix your problem