How to control paged display

[mshen]

Hi Friends,

I use SQL SELECT statement get a lot records fro database.I want to display them by page.for example I like display 20 records per page and use "next" "previous" to browse them.

Please let me how to do it.Please let me know if you have URLs for it.

Thanks so much.

[theeper]

You will need to use a LIMIT clause in your SQL statement. Please search this site, I have seen and answered this same question many times here.