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