<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Doi</title>


<link href="stil.css" rel="stylesheet" type="text/css">
</head>

<body>
<div id="wrapper">
<div id="header">
<h1>This is the Page Header</h1>
</div>
 
<div id="left-column">
<h2>The Navigation</h2>
<?php
include "meniu.php";
?>
</div>
 
<div id="right-column">
<h2>Sterge sau modifica nota</h2>
<?php
     include "conect.php";

	 $sql="SELECT studenti.nume, materii.denumire, note.nota, note.data, note.id FROM studenti,materii,note WHERE note.id_materie=materii.id AND note.id_student=studenti.id";
	 $rez= mysql_query($sql);
	?>
<table>
	<tr> <td>Nr.crt.</td> <td>Nume Student</td> <td>Materia</td> <td>Nota</td>  <td>Data</td> <td>Sterge</td><td>Modifica</td> 	 	
	</tr>
	<?php
$i=1;
		while($row=mysql_fetch_array($rez))
		{
			echo"<tr><td>".$i."</td> <td>".$row['nume']."</td> <td>".$row['denumire']."</td> <td>".$row['nota']."</td> <td>".$row['data']."</td> <td><a href=\"sterge.php?id=".$row['id']."\">şterge</a></td><td><a href=\"form_modi.php?id=".$row['id']."\">modifica</a></td></tr>";
$i++;
			}
	?>
	</table>
</div>
 
<div id="footer">
<p>The Page Footer Goes Here</p>
</div>
</div><!--aici se termina wrapperul-->


</body></html>