<HTML>
<HEAD>
<TITLE>PROVA ASP</TITLE>
</HEAD>
<BODY>
<?php
mysql_connect('localhost','username','password');
mysql_select_db('databasename');
// SQL Select query
$result = mysql_query("SELECT * FROM Studenti");
// Check if we had an error
if (mysql_error()) {
echo "Unable to retrieve record";
} else {
?>
<div align="center">
<center>
<table border="1" bordercolor="#111111" width="50%" id="AutoNumber1">
<?php
while($row = mysql_fetch_array($result)) {
?>
<tr>
<td width="25%">
<?php echo $row['id']; ?> </td>
<td width="25%">
<?php echo $row['nome']; ?> </td>
<td width="25%">
<?php echo $row['Cognome']; ?> </td>
<td width="25%">
<?php echo $row['Data']; ?> </td>
</tr>
<?php } ?>
</table>
<?php mysql_close(); ?>
</center>
</div>
</BODY>
</HTML>