sort decreasing by id?

[tranquillo]

hi..

I want to list some data from a mysql database and I want it to start with the latest entry.. the "id" is auto increasing so I thought it would be easy to just sort it decreasing by "id"... but I don't understand how I do this... I just need a simple sql query.

select decreasing * from whatever sort by whatever.id;
select * from whatever sort decreasing by id;

well... I don't get it...

-stefan

 

[laffreuxthomas]

select * from whatever order by id desc;

Thomas
---
A free GUI for your database:

http://www.sashipamelba.com

 

[tranquillo]

that was quick.. thanks desc like descending... should have known...

thanks again.

-stefan.