Sorting results from a mysql database

Hi everybody 🙂

Is it possible to sort results from a mysql table in the opposite way it normally does?

eg.. if i use something like:

   $result = mysql_query("select * from news order by id") or die (mysql_error()); 
   while($r=mysql_fetch_array($result))

and id was:

1
2
3
4

etc..

Could I make it sort out the info so it would appear on the page as:

4
3
2
1

etc..?

thanks 🙂 I hope that made sense.. lol

You can add ASC or DESC to the end of query.
(ASCending & DESCending)

$result = mysql_query("select * from news order by id DESC") or die (mysql_error());

use ORDER BY and DESC

$result = mysql_query("select * from news order by id") or die (mysql_error());
while($r=mysql_fetch_array($result)) ORDER BY id DESC

Thanks guys,

cahva, I saw that @ mysql.com's manual.. but for some reason it was giving me an error, untill I tried it again .. arhg! lol

Anyway, fixed it up 😃 Thanks!