ORDER BY date ASC
Posted: Thu Sep 29, 2005 3:37 am
Hi,
I have a query like so:
$query="SELECT id, DATE_FORMAT(date, '%d %M %Y') as date, event FROM events ORDER BY date DESC";
$result=mysql_query($query);
But it doesnt list the ORDER BY in a correct manner .. I am getting an order of:
30 November 2005
28 April 2008
25 December 2006
How do I correct this to make it order ASC:
30 November 2005
25 December 2006
28 April 2008
Thanks
I have a query like so:
$query="SELECT id, DATE_FORMAT(date, '%d %M %Y') as date, event FROM events ORDER BY date DESC";
$result=mysql_query($query);
But it doesnt list the ORDER BY in a correct manner .. I am getting an order of:
30 November 2005
28 April 2008
25 December 2006
How do I correct this to make it order ASC:
30 November 2005
25 December 2006
28 April 2008
Thanks