so im querying results from my mySQL DB and thats all fine. after that, this is the structure i have:
$result[0]:
-$row01
-$row02
-$row03
$result[1]:
-$row11
-$row12
-$row13
not completely accurate with the names but you get the idea. now what i want to do is compare the values of each row in $result[0] with each row in $result[1] so i do a
while($row0 = mysql_fetch_array($result[$y], MYSQL_BOTH))
{
//...do stuff
while($row1 = mysql_fetch_array($result[$z], MYSQL_BOTH))
{
//...do stuff
}
}
so now itll access $row01 and compare it to $row11 thru $row13. problem is, when it comes to $row02 and $row03, and it hits the second while loop, the loop will be skipped since the end of $row1 has been reached during the $row01 loop.
question is, is there a way to move back to $row11 ?
