All pastes #443545 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-04-16 21:22 UTC
rendered paste body
if (isset($_GET['quizid']))
{
	$quizid = $_GET['quizid'];
	$res = mysql_query("SELECT * FROM `questiontable` WHERE `quizid` = '$quizid' ORDER BY `questionnumber`");
	echo "<form name='quiz' action='student.php' method='POST'>";
	if (!mysql_num_rows($res) == 0)
	{
		while($row = mysql_fetch_array($res))	
		{
			$question = $row['question'];
			$questionid = $row['questionid'];
			echo "<br><b>" . $row['questionnumber'] . ": "; 
			echo $question . "</b><br>";
			$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 "<input type='radio' name='" .  $questionid . "' value='" . $answer . "'>";
				echo $answer . "<br>";
				}
			}
			else echo "invalid question id";
		}
		echo "<input type='hidden' name='quizid' value='" . $quizid . "'>";
		echo "<input type=submit name=submit value='Add'>";
	}
	else echo "invalid quiz id";
	echo "</form>";
}