reverse order for sql "ORDER BY"

[ruach]

I wonder if any one knows how to reverse an "ORDER BY" in a sql query. That is to say when I make my query to mysql and use "ORDER BY id" it returns the lowest number first. Is there any way to reverse that so that the highest number (most recent in my case) is on top ?

thanks much
-ruach

[eoghain]

Yes when you do an ORDER BY x what is really being interpreted is ORDER BY x ASC, you can reverse this by using ORDER BY x DESC.

ASC - Ascending
DESC - Descending

[ruach]

thats great, thanks !

-matthew