display newest n (say 10 numbers) records

[babulgogoi]

Hi,

Can someone please write me a small script which will show last/newest n (10 or 20 30 numbers) records in a mySQL DB? the DB db has a date field, a title, a description field.

Thank you very much.

http://www.flicks.in

[devinemke]

SELECT * FROM table ORDER BY date DESC LIMIT 10