How to decide how many rows display?

[mshen]

I use SQL select statament get the records from database.I want to know how to display 10 records per page and also add "next" and "prev" to broswer the records.

Please give me a source code demo.

Thanks

[Kilo]

In the SQL you can use LIMIT eg:

SELECT * FROM tablename LIMIT (0,10);

will give you the first 10 rows,

LIMIT (45,10) will give you ten rows starting at row 46