Paging through results from query based on form variables

[daneaffr]

I'm very new to this and really could use some help. I've got a Web app that has one form that collects data from the user and puts it into a mysql database and has another form that allows the user to select critiera to find records in the database and display them on the page.  All this is working just fine, but now that my database is getting more data in it, I want to add functionality to display 10 records on a page with results page navigation links so the user can move forward and backward in the results set.  This part is not working and I've put in echo statements to figure out what the code is doing.

 

The problem I'm having is that when the selection critiera pulls more than 10 records from the database, the first page of results is correct per the selection criteria entered by the user on the select form.  When the 'next' link is selected to review the second page of results, the query is executed again.  But this time the form variables have been reset and the results now contains the entire contents of the db.  The start record is set to look at the 11th instance of the results set, so the second page starts with the 11th record in the database instead of the 11th record in the original results set.

 

The original select statement is built by determining which criteria is selected using $_POST against each form variable.  How can I retain the form variables or the original select statement  so the second execution of the select statement results in the same results set as the first? The other option that may be better is to retain the original results set and avoid re-executing the select statement altogether.  But I don't know how to do that either.  Any suggestions, code samples or adivice is much appreciated!

[litebearer]

try ...

 

http://www.phpfreaks.com/tutorial/basic-pagination

[daneaffr]

Thank you for the reference!  I've looked at it briefly, but will take more time over the weekend to review it and see how much progress I can make.

 

[daneaffr]

I checked out this tutorial and it is very easy to understand and it works for displaying every record in the db, but it ignores the conditions set in the where clause based on the selection criteria in the form that calls the results page.  I'm so new to this and teaching myself as I go, so I'm befuddled as to why it is ignoring that.