database record on multiple pages

[powerofphp]

Hello,
I have have more then hundred record in data base when i display these on web page by accesing from database. problem is that i want that only 10 records be display on first page and there must be a next button at the bottom and when i click next button next ten records be display , and again same next button be display on next page and so on.............

plz help

😕

[steadyguy]

You will need to add a LIMIT clause to to your SQL. For example:
SELECT *
FROM my_table
LIMIT 0,10
Where 0 is where you want to start from, and 10 is how many records you want.

To make this work on many pages, pass a variable via the URL, and use it to calculate the appropriate numbers for the LIMIT clause before running the query.