Displaying results from db

[CRCameron]

When i am displaying my results from a database (just simple information firstname, lastname etc.) i know how to display it and sort it by either asc or desc...

my problem is that i want to display only the last 3 records to be added to the database

as i say i know how to make it desc so it reads from the bottom (so it is the last 3)

i just dont know how to set it so that it only shows 3 records instead of showing all the records from the table

[bogu]

Use

LIMIT 3

to your select ...
Look at the MySql SELECT SYNTAX for more details ...

[CRCameron]

Thanks a lot mate.

[bogu]

Now u can mark this thread as RESOLVED.