从php嵌入几次从mysql中获取行

i m dealing with 2 tables.I just want to know whether there is something code that helps me fetching rows for multiple times without writing same query for that many times: Example:

while($row1=mysqli_fetch_array($result1)) {
   while($row2=mysqli_fetch_array($result2)){ 
       //checking for some condition 
   } 
}

In above code unlike array we cant reset a variable outside the inner loop as follows

while($row1=mysqli_fetch_array($result1)) { 
   $number=0;//so that v can start from first row 
   while($row2=mysqli_fetch_array($result2)){
     //checking for some condition 
   } 
}

I m totally aware that rows and array are different,So i m asking if there is FOR loop we can use on rows?? like:

while($row1=mysqli_fetch_array($result1)) { 
  for(...){
    //so dat it will xecute no.of whileloops*no.of for loops.
  }
}

if not clear ask for more. Your suggestions are much obliged.

Edit: table: Year 1999 2000 2002 2004 2000 $result=mysqli_query($con,"select distinct Year from table_name"); dataset=mysqli_fetch_array($result)..

$dataSet1 = mysqli_fetch_all($result1);
$dataSet2 = mysqli_fetch_all($result2);
foreach($dataSet1 AS $row1){
  foreach($dataSet2 AS $row2){

  }
}

Something like this might work?

Try this (if i understood ):

while( list($row1,$row2) = array(mysqli_fetch_array($result1),mysqli_fetch_array($result2)) ){
   // check condition 
}

If I got it right, you want to match all the results of the first query against all the results of the second query.

In that case, you should first gather all the results of both queries in two PHP arrays (of arrays) and then work with these variables, like so:

$list1=array();
while ($row=mysqli_fetch_array($result1)) $list1[] = $row;
$list2=array();
while ($row=mysqli_fetch_array($result2)) $list2[] = $row;

foreach ($list1 as $row1)
foreach ($list2 as $row2)
{
    match_against ($row1, $row2);
}

Note that it looks very much like an SQL JOIN done in PHP.
Why not, as long as the number of results stay within reasonable bounds.

But if it's not the case (i.e. $list1 or $list2 could contain hundreds of elements), be aware that your code will very likely be a lot less efficient than what a DB engine can do.

That's why you might want to consider replacing this code with an SQL query.