include 'connect.php';
$username = $_SESSION['username'];
$sql = mysql_query("select id from Quiz_users where username = '$username'");
$stu = mysql_fetch_row($sql);
$num = mysql_num_rows($sql);
if ($num > 0)
{
echo "
Quiz Scores for $username:
";
$studentid = $stu[0];
$newsql = "select * from Quiz_scores where studentid = '$studentid'";
$result = mysql_query($newsql);
echo "
";
while ($row = mysql_fetch_array($result))
{
$quizid = $row['quizid'];
$score = $row['score'];
$newsql = mysql_query("select quizname from currentquizzes where id = '$quizid'");
$newrow = mysql_fetch_row($newsql);
$quizname = $newrow[0];
echo "| $quizname | $score% |
";
}
echo "
";
}
echo "
back to student page";
?>