How to create page index

Hi, I am new to php. I want to know how to create a single page with multiple index to display certain amount of records. Let say I have total of 100 records to display but I just want to list 10 records. So that's mean I need 10 index to display them all.

Example:

1 2 3 4 5 6 7 8 9 10 (This is the index)

First 10 records go here for index no 1.

I hope you understand my question...

Code:

---

SELECT * FROM YourTable WHERE YourFiled = 'Something' LIMIT 10

---

Is there any simple example on how to implement this? Tq

Which DBMS are you using?

You need to find out how to connect and pull out the data from your appropriate database.

The rest really depends on how you want to accomplish this. Do you want to automatically pass the values via POST method, or would you send it via get?