How to limit results in mysql and pagination in php?

[gilgalbiblewheel]

How do you limit results in mysql and pagination in php?

[r937]

with the LIMIT option in the ORDER BY clause

as for pagination, there are lots of threads about pagination over in the php forum, go have a search