";
echo("
Choose a Quiz to be deleted:
");
$enteredusername = $_SESSION['username'];
$delete = $_GET['delete'];
$id = $_SESSION['id'];
$quizid = $_GET['quizid'];
if ($delete == 'yes')
{
$newsql = mysql_query("select quizname from currentquizzes where id = '$id' AND teacherid = '$enteredusername'");
$row = mysql_fetch_row($newsql);
$name = $row[0];
$sql = "drop table $name";
$result = mysql_query($sql);
$answers = $name."_answers";
$sql = "drop table $answers";
$result = mysql_query($sql);
if (!$result) echo mysql_error();
$poss = $name."_poss";
$result2 = "drop table $poss";
mysql_query("delete from Quiz_results where quizid = '$quizid'");
$result2 = mysql_query($result2);
if (!$result2) echo mysql_error();
mysql_query("delete from currentquizzes where id = '$quizid'");
}
$sql = mysql_query("select id,quizname from currentquizzes");
while ($row = mysql_fetch_array($sql))
{
echo "
Delete $row[1]";
}
echo "
![\"Quiddle,](\"./images/quiddle_masthead.jpg\" "\\"quiddle\\"")