how to select last 10 records?

[nightowl]

I was wondering how to select the last 10 records from my database. I know I can sort them using desc and them using limit 10. But they I get them in reverse order. Is there a way to get the last 10 records in the right order ? (without having to store the results in an array and resorting that array) ?

[_SuperString]

dont think so, what wrong with doing this?

$result = rsort(mysql_fetch_array($query));

[Traduim]

You could always get the number of records in your table (using SELECT Count(*) ) and then use LIMIT totalrecords-10,10