Reteriving set of records from MySql using PHP - Help Me

HI,

I am implementing pagination in my site. I want to display 10 rows each page. how can a reterive only 10 rows from MySql. what is function to use from PHP.
Please help me.

 

SELECT * FROM yourtable LIMIT 0, 10

Code (sql):

 

You'll most likely be using MySQL DB? If so you're going to be using the PHP MySQL functions.

Namely:
mysql_connect()
mysql_select_db()
mysql_query()
mysql_fetch_assoc()

 

For the 1st 10,

SELECT * FROM yourtable LIMIT 0, 10

For the 2nd 10
SELECT * FROM yourtable LIMIT 10, 10

etc etc ...