MySQL 4: Select last 100 records from table

I have a table in which items are constantly added with a date and time indicator, but I need to retrieve from it only the last 100 items added.

Any help will be greatly appreciated, thanks!

PHP Code:

---

Select * From TABLENAME Order BY DateField Desc Limit 100 


---

Thanks! :)