PHP | pagination | DB
PHP | pagination | DB
Out of context: Reply #1
- Started
- Last post
- 5 Responses
- UndoUndo0
ask him how he's doing it, if he return all the results and counts through until it gets to the required start point it will get heavy when there are lots of rows.
Optimized queries:
he needs to use a statement like this
SELECT column FROM table
LIMIT 10 OFFSET 10whihc would return 10 results starting from the 10th one ie. 11-20