Next and previous buttons..

[Anon]

How might i got about creating a functino with php and mysql saying that if their are more than 10 entires then to view the 10 then have a next button for the next 10 and a previous link?
Thanks for your help.
Anthony

[terje-s]

You'd use mysqls LIMIT.

SELECT * FROM table LIMIT 10;

SELECT * FROM table LIMIT 10,10;

etc. Experiment and read the docs.