What is the best way to paginate results in php
pagination, php
Solution
Use limit in SQL! Every time!
Otherwise you're throwing around considerably more data than you need to, which makes your scripts unnecessarily slow, and will lead to scalability problems as the amount of data in your tables increases.
Limit is your friend!
Problem
I need to display many pages of news in a site. Should I do the pagination in the database query using `LIMIT` or with the PHP script after getting all the results?