validating multiple checkboxes

[mlai4167]

Need help. Stuck! How do I validate multiple checkboxes once the submit button is pressed?

Here are my Tables:
tbl_question
+-------------+
| Field |
+-------------+
| question_id |
| test_id |
| question |
+-------------+

tbl_answer
+-------------+
| Field |
+-------------+
| answer_id |
| test_id |
| question_id |
| answer |
+-------------+

tbl_correct
+-------------+
| Field |
+-------------+
| correct_id |
| test_id |
| question_id |
| answer_id |
| correct |
+-------------+

Here is my code so far:
$course_id = "HST101";

$sql_get_test_id = "SELECT * FROM tbl_test WHERE course_id='$course_id'";
$result_get_test_id = mysql_query($sql_get_test_id);
$myrow_get_test_id = mysql_fetch_array($result_get_test_id);
$test_id = $myrow_get_test_id["test_id"];

printf("<form>\n");
$result_question = mysql_query("SELECT * FROM tbl_question WHERE test_id='$test_id'",$db);
$count_questions = mysql_num_rows($result_question);
echo "<table border=0>\n";
printf("<tr><td>&nbsp</td></tr>\n");
$x=0;
$y=0;
while ($row_question = mysql_fetch_row($result_question)) {
printf("<tr><td>%s</td></tr>\n", $row_question[2]);
$question_ids[$x]=$row_question[0];

$result_answer = mysql_query("SELECT * FROM tbl_answer WHERE question_id='$question_ids[$x]'",$db);
$count_answers = mysql_num_rows($result_answer);
while ($row_answer = mysql_fetch_row($result_answer)) {
printf("<tr><td>%s</td><td><input type='checkbox' value='answer' unchecked name='%s'><td></tr>\n", $row_answer[3], $row_answer[3]);
$answer_ids[$y]=$row_answer[0];
$y++;
}

printf("<tr><td>&nbsp</td></tr>\n");
$x++;
}
echo "</table>\n";
printf("</form>\n");

$result_correct_answer = mysql_query("SELECT answer_id FROM tbl_correct WHERE test_id='$test_id'",$db);
$count_correct_answers = mysql_num_rows($result_correct_answer);
echo "<table border=1>\n";
echo "<tr><td>correct_id</td></tr>\n";
$z=0;
while ($row_correct_answer = mysql_fetch_row($result_correct_answer)) {
printf("<tr><td>%s</td></tr>\n", $row_correct_answer[0]);
$correct_answer_ids[$z]=$myrow_correct_answer[0];
$z++;
}
echo "</table>\n";

---

Thanks in advance for any help.

[subrata]

hi michael,

first you should name the chek boxes as
$row_answer["test_id"] . "" . $row_answer["question_id"] . "" . $row_answer["answer_id"] ,

so the name of the check box for choice 1 of
test="php", questinid="q01", answer_choice="c01" will be "php_q01_c01".

now while validating the form select from the correct answer table select test_id,question_id,correct_answer_id for the corresponding test. concatenate them using "_" as delimeter as we did in naming the check boxes earlier. now put the string in a variable (say $correct_answer) then check <?php isset($$correct_answer) ?>. if the correct answer is checked then the variable will be set, otherwise wrong answer is selected for the corresponding question.

hope this will solve your problem.
regards
subrata