如何使用for循环遍历mysql_fetch_array（）？

while

$i

$q = \"SELECT test_id, title, subject, type, creation_date FROM tests WHERE user_id=\'$user_id\' LIMIT 10\"; //select first ten of users tests
$r = mysqli_query ($dbc, $q) or trigger_error(\"Query: $q\\n<br />MySQL Error: \" . mysqli_error($dbc));

if (mysqli_affected_rows($dbc) > 0) {//if the query ran correctly and the test details were gathered from the database

    $row = mysqli_fetch_array($r, MYSQLI_ASSOC)
    $i = 0;

    while ( $row = mysqli_fetch_array($r, MYSQLI_ASSOC) ) {
        $test_id = $row[\'test_id\'];
        $test_type = $row[\'type\'];
        $creation_date = $row[\'creation_date\'];
        $creator = $user_id;
        $title = $row[\'title\'];
        $subject = $row[\'subject\'];

        $q = \"SELECT tag_id FROM test_tags WHERE test_id=\'$test_id[$i]\"; //select tags corresponding to this test
        $r2 = mysqli_query ($dbc, $q) or trigger_error(\"Query: $q\\n<br />MySQL Error: \" . mysqli_error($dbc));

        $i += 1;
    }
}

//select first ten of users tests
$q = \"SELECT test_id, title, subject, type, creation_date FROM tests WHERE user_id=\'$user_id\' LIMIT 10\"; 
$r = mysqli_query($dbc, $q);
$i = 0;
//loop through result object:
foreach ($r as $row) {
  $row[$i][\'test_id\'] = $test_id;
  //...

  $q = \"SELECT tag_id FROM test_tags WHERE test_id=\'$test_id[$i]\"; //select tags corresponding to this test
  $r = mysqli_query ($dbc, $q) or trigger_error(\"Query: $q\\n<br />MySQL Error: \" . mysqli_error($dbc));

  //loop through the new result:

  foreach ($r as $tag) {
    $tags[] = $tag;
  }

  $i++; //increment counter.

  //Not sure where you\'re going from here, but...

  $row[$i][\'tags\'] = $tag; //add tags array to $row
  return $row[$i];
}