show 100 rows, if more a link will display to show next 100
Posted: Tue Sep 28, 2010 12:45 pm
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
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