While loop variable issue

[mlvnjm]

Hey all,

I'm trying to access two variables $tableid and $itemindex which are set inside a while loop. When i echo it from the while loop i get the desired value, but when i echo them from outside the loop i don't get anything. Any suggestions? Thanks.

Here's the code:

	while($row = mysql_fetch_array($result))
	{
		$tablename=$row['TableName'];

	$result2=mysql_query("SELECT * FROM $tablename 
							WHERE ProductID='$productid' LIMIT 1");		
	if($result2)
	{
		$row2=mysql_fetch_assoc($result2);
		$tableid=$row2['TableID'];
		$itemindex=$row2['ItemIndex'];
		echo "$tableid $itemindex";

	}
}

[sarahk]

could it be something to do with using mysql_fetch_assoc in the second query. What happens if you use mysql_fetch_array?

[mlvnjm]

No change.. still the same.

[mlvnjm]

Found out what the problem was. When it finds the record it sets the variables, but when it loops through the rest of thew rows it resets the variables. I just set another condition inside the if condition to set the variables only for the particular productid. Thanks for your suggestions sarahk.