Select by position

[jacquesy]

Hello.

I am having trouble in querying my database. I have a php page that selects the top 2 records in order of their entered date and then print out all of the fields for these records using a while statement, this is working fine:

SELECT * FROM manufacturer order by dbManDate limit 2;

Now I want to query the database for the second time, this time selecting * from the 3rd, 4th and 5th record.

How do I select the 3rd, 4th and 5th records and miss out the first 2?

Thanks!

[craigh]

RTM!

http://www.mysql.com/doc/en/SELECT.html

search for LIMIT on that page.

[jacquesy]

Ive found it, thanks