[SOLVED] MySQL DB - SQL ORDER BY
Posted: Wed Jun 30, 2004 10:35 am
hi all,
Basically I have the following SQL statemnt:
Now the returned results of this are:
It seems to have ordered them by the 'd', the last article should actually be at the top.
I'm a little stumped on this, I have no idea what I need to do to sort them correctly.
Cheers for any advice offered.
Jim
Basically I have the following SQL statemnt:
Code: Select all
$sql = "SELECT sid, title, DATE_FORMAT(creation_date,'%d/%m/%Y') as creation_date FROM my_db WHERE category = 'product' ORDER by creation_date desc LIMIT 5";Code: Select all
new discovery 29/04/2004
New Release 27/01/2004
Server Support 27/01/2004
Released 12/03/2004
Coming soon! 11/06/2004I'm a little stumped on this, I have no idea what I need to do to sort them correctly.
Cheers for any advice offered.
Jim