Last Ten Rows Query

[ez2c]

Hello,

I'd like to Select the last ten rows entered into my MYSQL database, but I'm not sure how to write the query. I assume it would be based on the number of rows - 10.

Any help is appreciated. Thanks

[sandman]

Hi,

It may be done like this (of course using your own table and fileds)
$q = 'select field1, field2 from your_table order by field1 desc limit 10;';

cheers