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