ordering dates

[Ross Hulford]

$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title, 
id, display FROM news ORDER BY date DESC ");

I have the query above the problem is oders them like so
30/05/2007
29/07/2007
25/0/2007


The order is taken by the first number. Is there any way to order them 
properly without a timestamp?


Ta,

R. 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]