show 100 rows, if more a link will display to show next 100

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Smudly
Forum Commoner
Posts: 71
Joined: Wed Jun 09, 2010 10:09 pm

show 100 rows, if more a link will display to show next 100

Post by Smudly »

I am displaying rows from a database onto a page using:

while($row=mysql_fetch_array($query)){

echo $row['name'];

}

I need to figure out how to limit the rows shown to the page to 100. And if there are 100 rows on the page, a link will be displayed at the bottom, that says "Next 100". Then this will display the next 100 rows.
Can you give an example how to do this please?

Thanks
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: show 100 rows, if more a link will display to show next

Post by Jonah Bron »

McInfo made an example of that (called "pagination") here:

viewtopic.php?f=1&t=99545&p=537019#p537019
Post Reply