How to show limited records per page

[Anon]

Hello and happy new year,

My question is:
How can I show limited number of records per page?
for example, I need to display the records from a table (mysql) on a page, but since the number of records are too long, I need to break them up per page.

Any Idea, How can I do this and generate automatically the number of links needed in the bottom of the page, so when the user clicks on the for example page 2 it would show the remaining records.?
Thanks much for your help

please send your response to
Dariush@sympatico.ca

[vincente]

first: this forum exists to share information. All answers are posted here, so you should come back here to read the answers. We don't email to you personally.

Second, as you are person number 5467 who asks this question without even bothering to look do a search first, I'm trying to keep cool and give you a sort of answer:

RTFcolumn:http://www.phpbuilder.com/columns/rod20001214.php3
or
http://www.phpbuilder.com/columns/rod20000221.php3

[Anon]

Thank you So very much for the helpfull links.

I tried the search, but since did not specify the correct term (Building Next/Prev Buttons for Query Results), never found anything.

Anyhow, thank you.

Dariush