Here are the results for $studentname";
$newsql = "select questionwrong from Quiz_results where quizid = '$quizid' and studentid = '$studid'";
$newresult = mysql_query($newsql);
//question will be in numeric form
while ($resultrow = mysql_fetch_array($newresult))
{
$wrongquestion = "$resultrow[0],";
} //closes while loop
$wrongquestion = substr($wrongquestion,0,-1);
$wrongquestion = explode(",",$wrongquestion);
$questions = mysql_query("select * from $answers");
$numfields = mysql_num_fields($questions);
$row = mysql_fetch_array($questions);
$quizquestion = mysql_query("select * from $quizname");
$newrow = mysql_fetch_row($quizquestion);
echo "Correct answers in
green, Wrong answers in
red";
echo "
| Question | Correct Answer | Answer Given | ";
for ($i=1;$i<$numfields;$i++)
{
echo "| ";
echo "$i. $newrow[$i]";
echo " | ";
echo "$row[$i] | ";
if (in_array($i,$wrongquestion))
{
$key = array_search($i,$wrongquestion);
$key = $wrongquestion[$key];
$finalsql = "select answergiven from Quiz_results where questionwrong = '$key' and studentid = '$studid' and quizid = '$quizid'";
$finalsql = mysql_query($finalsql);
$finalrow = mysql_fetch_row($finalsql);
$badanswer = $finalrow[0];
echo "$badanswer";
}
else
{
echo "$row[$i]";
}
echo " | ";
echo "
";
}
?>
