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
show 100 rows, if more a link will display to show next 100
Moderator: General Moderators
- 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
McInfo made an example of that (called "pagination") here:
viewtopic.php?f=1&t=99545&p=537019#p537019
viewtopic.php?f=1&t=99545&p=537019#p537019