show only a few

[Anon]

sorry, but I'm quite new to php. I have a database and I want to show on a page only the 4 newest infos, which are stored in the database.
how can I do that?
I still can't understand completely $first and $last, and how to use it for this.

[Anon]

SELECT TOP 4 * FROM Table1 ORDER BY ENTERDATEFIELD

This SQL statment is working in Microsoft SQL Server.

It may not work in the database you have.