while loop within foreach

I've got a form with questions which gets answered. Then o开发者_如何学Gon the following page I'm trying to validate the questions to see if the answer is correct or not because eventually I must work out a percentage for the test.

$tid1 = $_SESSION['tid'];
$departmentid = $_SESSION['deptid'];
$userid = $_SESSION['userid'];

foreach($_POST['question'] as $key => $answer) {
    include 'datalogin.php';
    mysql_query("INSERT INTO ex_answer (id,class_name,testname,name,percentage,qnr,answer_chosen,points_scored,result)
VALUES ('0','$departmentid','$tid1','$userid','0','$key','$answer[0] $answer[1] $answer[2] $answer[3] $answer[4] $answer[5] $answer[6] $answer[7] $answer[8]','0','0')");

    $sql1="SELECT * FROM ex_question WHERE test_name = '$tid1' AND q_nr = '$key'";
    $result1=mysql_query($sql1);
    while($row1 = mysql_fetch_array($result1)) {
        $q_nr=$row1['q_nr'];
        echo $q_nr;
    }
}

The problem is (I think) that it is not selecting the question number q_nr = '$key' correctly from the table because echo $q_nr gives no output

---

If you are getting a valid result (Test the sql in your Database client ) then you should just use the following to access it as an associative array:

mysql_fetch_assoc($result1); 

instead of the mysql_fetch_array() or use mysql_fetch_array($result1, MYSQL_ASSOC)

Test what is being returned to you, comment out your while loop and then do:

$row1 = mysql_fetch_array($result1);
print_r($row1);

before you while loop add the following for validation:

if (!$result1) {
    die('Could not query:' . mysql_error());
}

---

Use mysql_fetch_assoc to be able to use column name indexes on returned array.

---

You can also output the SQL and test it on the DB, that will show that you are getting the expected results