Ordering mysql data from id highest first Options

[joyful]

Hey,

I have a very simple question:
I am using this code to order my MYSQL data:

CODE

$query = "SELECT * FROM news ORDER BY id";

How can I display my data by id with highest id number first (counting down)? I am using auto increment on id and need to display id highest first.

Thanks in advance.

--

[Frederiek]

See http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html .

[joyful]

Thanks a lot Frederiek, this is exactly what I wanted!

--

[Frederiek]

You're welcome.