if (isset($_GET['quizid'])) { $quizid = $_GET['quizid']; $res = mysql_query("SELECT * FROM `questiontable` WHERE `quizid` = '$quizid' ORDER BY `questionnumber`"); echo "
"; if (!mysql_num_rows($res) == 0) { while($row = mysql_fetch_array($res)) { $question = $row['question']; $questionid = $row['questionid']; echo "
" . $row['questionnumber'] . ": "; echo $question . "
"; $result = mysql_query("SELECT * FROM `answertable` WHERE `questionid` = '$questionid'"); if (!mysql_num_rows($result) == 0) { $i=1; while($row = mysql_fetch_array($result)) { $ans[i] = $row['answer']; $i++; } shuffle($ans); foreach ($ans as $answer) { echo ""; echo $answer . "
"; } } else echo "invalid question id"; } echo ""; echo ""; } else echo "invalid quiz id"; echo "
"; }