PHP/MySQL Pagination
Solution 1:
SELECT col FROM table LIMIT 0,5; -- First page, rows 1-5
SELECT col FROM table LIMIT 5,5; -- Second page, rows 6-10
SELECT col FROM table LIMIT 10,5; -- Third page, rows 11-15
Read the LIMIT section on the MySQL SELECT helppage. If you want to display the total number of rows available, you can either do an extra count, or use the ROW_COUNT function.