All pastes #443498 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-04-16 20:52 UTC
rendered paste body
if (isset($_GET['quizid']))
{
	$quizid = $_GET['quizid'];
	$res = mysql_query("SELECT * FROM `questiontable` WHERE `quizid` = '$quizid'");
	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)
			{
				while($row = mysql_fetch_array($result))	
				{
					echo "<input type='radio' name='" .  $questionid . "' value='" . $row['answer'] . "'>";
					echo $row['answer'] . "<br>";
				}
			}
			else echo "invalid question id";
		}
		echo "<input type=submit name=submit value='Add'>";
	}
	else echo "invalid quiz id";
	echo "</form>";
}