Displaying a certain number of results

[Anon]

Like in the search here at phpbuilder you can Display a certain number of results per page, and have the number of pages needed displayed at the bottom of the page automatically.

how do you do this?

thanx

[Anon]

Yea, it oo would like ot know hod to do this. I need to display the records from tables in my database, but displaying all the records from each table on a single page would take forever to load.

How can i make it so it only loads say 25 on the first page and they goto the bottom of the page and it has all the pages listed, so if there was 150 records the bottom would say like:

Page: 1,2,3,4,5,6..

Or something like that?

Can someone help me out?

[Anon]

Use a for or while loop, where you have an integer variable that is increased by 1 each time a record is displayed and have the loop stop at 25 or whatever number you choose. Then to build the Page: 1, 2, etc links, pass a variable ($start or something) which tells what the initial value of the integer value should be, and have the loop stop at said value + 25. There are MySQL functions to either move the pointer to the $start variable, or where you can pass the $start as a row number to get the value of whatever column in that row.

Hopefully I didn't word that too confusingly. 🙂