prepare("select questionid,question from 3312questions where questionid not in (select question from 3312useranswers where sessid = '$sessid') order by rand() limit 1");
$mason->execute();
$row = $mason->fetch();
$qid = $row[0];
echo 'Question '. $qid.'
';
$question = $row[1];
$canswers = $dbh->prepare("select answer from 3312canswer where questionid = ?");
$canswers->bindValue(1,$qid);
$canswers->execute();
$crow = $canswers->fetch();
$answers[] .= $crow[0]; //<=-- this is the correct answer
$correct = $crow[0];
$wanswers = $dbh->prepare("select answer from 3312wanswers where questionid = ?");
$wanswers->bindValue(1,$qid);
$wanswers->execute();
while ($wrow = $wanswers->fetch())
{
$answers[] .= $wrow[0]; //<=-- these are the wrong answers
}
shuffle($answers);
?>
';
unset($foo);
}
?>
next