<?php

session_start();

?>
<?php
include_once("db.php");
$uname = $_SESSION['user'];

if(empty($uname))
	echo "<br /><a href='signinform.php'>Please Login</a>";
else{
	$teach = mysql_query("SELECT teacher FROM phplogin WHERE username= '$uname'");
	if(!empty($teach)){
		$sql = mysql_query("SELECT * FROM grades");
		}
	else{
		$sql = mysql_query("SELECT Class, Assignment,grade FROM grades WHERE username= '$uname'");
		}

	$fields_num = mysql_num_fields($sql);
	echo "<h1>My Grades</h1>";
	echo "<table border ='1'><tr>";
	for($i=0; $i<$fields_num; $i++)
	{
	    $field = mysql_fetch_field($sql);
	    echo "<td>{$field->name}</td>";
	}
	echo "</tr>\n";

	while($row = mysql_fetch_row($sql))
	{
	    echo "<tr>";

	    foreach($row as $cell)
		        echo "<td>$cell</td>";

		    echo "</tr>\n";
	}
	}
	?>