0) echo "Correct! You answered $ans
";
if ($numres == 0) echo "INCORRECT!
The correct answer is $correctanswer!
You answered $ans!";
//insert user answers for user progress and we need move them up to the next question
$inssql = mysql_query("insert into 3312useranswers (answer,timeanswered,sessid,question,userid) values ('$ans',now(),'$sessid','$question','$userid')");
if (!$inssql) echo mysql_error();
$sql = mysql_query("select questionid,question
from 3312questions where questionid not in (select question from 3312useranswers where sessid = '$sessid') order by rand() limit 1");
//if num rows == 0; we can query results and give
$num= mysql_num_rows($sql);
if (mysql_num_rows($sql) == 0)
{
$numright = 0;
$answers = 0;
$answersql = mysql_query("select answer,question from 3312useranswers where sessid = '$sessid'");
while ($row = mysql_fetch_array($answersql))
{
$answer = $row[0];
$question = $row[1];
$innersql = mysql_query("select answer from 3312canswer where questionid = '$question'");
$innerrow = mysql_fetch_array($innersql);
$corranswer = $innerrow[0];
if ($answer == $corranswer) $numright++;
$answers++;
//the time it took to take the quiz
}
echo "You have $numright out of $answers!";
exit();
}
$row = mysql_fetch_row($sql);
echo $row[1]."
";
$qid = $row[0];
$anssql = mysql_query("select answer from 3312canswer where questionid = '$qid'
union
select answer from 3312wanswers where questionid = '$qid' order by rand()");
if (!$anssql) echo mysql_error();
echo "";
?>