PHP/MySQL Pagination

Question

I am new to php and sql, and i have one tiny question about how to realize sql query , that can:

• Take for example 5 entries from DB, insert them on 1st page (1-5)
• Than take next 5 entries from same DB and insert them on another page (5-10)
  and so on :)

Thank you )

Answer 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.