Let's say I have a rather large database, with many rows, and let's say that searching can yeild up to 200 results. How should I go about splitting these results into different pages, and have a list of page numbers?
example:
186 results for "Blue". Viewing page 3 of 5.
<-- previous ( 1 2 3 4 5 ) next -->
I've managed to do the previous and next page links, and it works great.... but with a large database, it can get slow because it does the query all over again, only printing the results for the page being viewed.
Ideas?
Best way to do multiple page search results
Moderator: General Moderators