PHWinfo - Afficher un message

12/09/2007, 22h49

$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.

12/09/2007, 22h49	#1
Ross Hulford Messages: n/a Hébergeur:	ordering dates $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.