ORDER BY COMMAND

[dannybrazil]

Hello

i have this code written :

 

$result = mysql_query("SELECT * FROM "my table" ORDER BY Date")

 

and i want to get the database to show on my page sorted by the date , newest FIRST and down twards the oldest

 

some one ?

 

thanks

[cooldude832]

the parameter ASC, DESC can be added to any order by query to change direction of the ordering using natural sorting method i.e integer, float or strings

[rhodesa]

Yeah, so as long as your 'date' column was some sort of Date/Time type or even and integer with a unix timestamp in it, it would be:

 

$result = mysql_query("SELECT * FROM `tableName` ORDER BY `date` DESC");

[Codein]

You also need to fetch the data from the result.

 

while ($info = mysql_fetch_assoc($result)) {
  echo("$info['name'] - $info['foo'] - $info['date']");
}

 

You shouldn't use the above code though. It should give you a good idea on how to return the data though.

[dannybrazil]

cool

 

working

 

10x