reverse order

[fizzwizz]

I can currently call data from a field using

$result = mysql_query("SELECT * FROM news ORDER BY id",$link_id);

id contains a column of numbers. I would like to retrieve them in reverse order .. ie highest numerical value first. How do I do that?

[HalfaBee]

$result = mysql_query("SELECT * FROM news ORDER BY id DESC",$link_id);

HalfaBee

[fizzwizz]

Many thanks .... Fizz