PHP Paginating

[webmasterjunkie]

OK, I have come up with a way to rank the pages in my searchable website.
User types in a search query and hits search. They go the to search results page and all of the pages that match that search are displayed as php links to another page that stores the term and page that the user clicked. Every so often I will evaluate the "votes" that are cast and make them more relevant results.

Problem now is paginating my results. I have googled myself to death trying to get some help on this. Tried many different codings and still no help.
Here's the part where some help would be nice. I am going to offer sposored results to my search results page based on the query. If someone can help me paginate my results I would be more than willing to give them free sponsorship.

To view the search got to http://www.homesearch-md.com

[steve0]

At the end of your search query.. use 'limit' and 'offset' to break your results into chunks for each page..

[Downright]

If you are not working with a lot of data you can simply do below:

You have a dropdown box to select amount of results per page OR you have a set amount. We'll call this $aResults.

select count(*) from $table $where;

Then take the result and divide it by $aResults;

$pages = $count / $aResults;

Will give you x number of pages.

From here store what page you are in a hidden text box. And if search or amount of results change then change page # back to 1.

$DB_startRes = $pageOn * $aResults;
select * from $table $where limit $DB_startRes, $aResults;

So if you were on page 5 showing 10 results per page then this would give you results from 50-60. Then at the bottom you can do << < 5,6,7,8,9 > >> as links that just simply pass the page #. This should work to your hearts desire.

Sorry, if it isn't very clear. Please feel free to email me and I can explain better.