June 2008
Php MySQL pagination with one database query
Pagination is one of the simple features of a site if used right can be a great feature. For something very simple it seems to be a resource hog. For a while I have been looking for a way to paganate with out issuing two database queries. After some quick searching I could not find what I was looking for, so I came up a method that uses a one query + a sub-query.
Quick Review
The method that I have seen the most, looks like some like this.