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

[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

[fortnox007]

SELECT * FROM your_table LIMIT 0, 100  // first 100
SELECT * FROM your_table LIMIT 100, 100 // 101 till 200
SELECT * FROM your_table LIMIT 200, 100 // 201 till 300