Limiting MySQL Query Results (With Pagination)
Combining the power of a mySQL database with the flexibility of PHP allows even the most amateurish developer to create websites loaded with thousands of pages of information. But what do you do if you don't want to display all your QUERY data in one large lump? Can you imagine Google if it showed you 30,000 search results on a single page? To get around this problem we can use PHP's integral LIMIT function to restrict the number of results displayed on one page, and then set start and end points to allow previous/next page links to work. This may initially sound quite difficult given PHP's automatic nature, but once you understand the concept behind simple pagination you'll wonder how the technique eluded you in the first place.