Problem with Pagination php

[zlaws]

i need to create a pagination code for php. i found many php codes around the web and found them very usefull, but never found one which really suited my needs.

What i need is:

1) i select which category i need to search for from a FORM, then i sumbit the result.

2) in the viewresult page you get the value of the category chosen via the $_POST function

$category =$_POST[category];

then the catergory is searched for from the MYSQL database

sql = ..... WHERE category=\"$category"\

Go to next page

with the part of code where i need to go to next page i need to send the value of the category

the problem i am finding is that since it is refreshing on the same page the value of category is coming to "null" since the first value of category was taken from another page with the $_POST function.

is there a way how i can overcome this problem?

hope i explained my self: i will try and post the code later on

[Ashley_Sheridan]

In each page you can use hidden form fields to store the input from the original form. If you prefer to use links, then form fields and post data is not available, so you need to put all the data into the URL of the link:

print "<a href=\"somepage.php?category={$_REQUEST['category']}&page=$page\">page x</a>";

If you change the parts of your code that look for $POST variables to look in $REQUEST instead, you should run into little in the way of problems, as $REQUEST is an amalgamate array of $GET and $_POST. You will run into trouble if you are using get and post together and have two variables of the same name. I can't remember which one takes precedence.