<!DOCTYPE html >
<html>
<head>
<meta charset=UTF-8>
<title>Template</title>
<link href="stil.css" rel="stylesheet" type="text/css">
</head>

<body>
<div id="wrapper">
 
<div id="nav">
<?php
include "meniu.php";
?>
</div>
<div id=clear></div>
<div id="continut">
<h2>Notele strudentilor din scoala noastra</h2>
<?php
	include "functii.php";
	include "conect.php";
	$sql="SELECT * FROM studenti,note,materii WHERE
	note.id_materie=materii.id AND
	note.id_student=studenti.id
	ORDER BY nume ";
	$rez=mysqli_query ($conexiune,$sql);
?>
<table>
		<tr>
			<th>Nr Crt</th>
			<th>Nume</th>
			<th>Prenume</th>
			<th>Materia</th>
			<th>Nota</th>
			<th>Data</th>
		</tr>
			<?php
				$i=1;
				while($row=mysqli_fetch_array($rez))
				{
					echo"<tr";
						if($i%2==0)
							echo" class=\"stil1\"";
						echo"><td>".$i."</td>
						<td>".$row['nume']."</td>
						<td>".$row['prenume']."</td>
						<td>".$row['denumire']."</td>
						<td>".$row['nota']."</td>
						<td>".mysql2german($row['data'])."</td>
						</tr>\n";
					$i++;
				}
			?>	
</table>
</div>

</div><!--aici se termina wrapperul-->


</body></html>