Last xx Records

I am trying to figure out a way to write a query that would select the last ten files that have been created in a table. The table has a Primary Key (just an auto_increment integer). The table also has a column containing the timestamp of each file also.

Also I would like to be able to use a limit function such as LIMIT 5,10 (and variations of this), while I assume this would be the same as any other select I figured I should include it just in case that would change the parameters of the query.

------------------
Luke Bowerman
new media arts
www.judebowerman.com/nma

Try:

SELECT * FROM mytable ORDER BY date_column DESC LIMIT 10;