Having a variable problem

Josheeyy

I am passing a value from one page to another to do a search. The first record is found, the problem is thta there are other records that meet my search critiria and get an error when I try to move to the next record. I am using $post to get the information from the first page. The problem seems that the value of $post is lost. Can someone please help me with this problem. I am about to start pulling my hair OFFF!!!!

blindeddie

after you display the first result are you going to a new page to display the second result? If so, why not display all the search results on one page? I am a little confused about what you are trying to do here, try to be more specific.

cgraz

could you also post some code? And I'm assuming this was just a typo, but $post is different from $POST

Cgraz

Josheeyy

mysql_select_db($database_PHpMysql, $PHpMysql);
$query_rsUpdateSoft = "SELECT * FROM soft "
." WHERE soft.tagno ='".$_POST['tagno']."'";
$query_limit_rsUpdateSoft = sprintf("%s LIMIT %d, %d", $query_rsUpdateSoft, $startRow_rsUpdateSoft, $maxRows_rsUpdateSoft);
$rsUpdateSoft = mysql_query($query_limit_rsUpdateSoft, $PHpMysql) or die(mysql_error());
$row_rsUpdateSoft = mysql_fetch_assoc($rsUpdateSoft);

The thing which I think is not working properly is the query itself. $POST gets its value from another page. It finds the 1st record, but when I am trying to move to the next record which also meets the critiria is errors out. It looks like $POST does not keep its value after the first record is found. So what I have been trying to do is make $_POST keep is value through the whole query.

Thanks again guys for taking the time in helping me out.