Codice PHP:
<html>
<head><title></title></head>
<body>
<?php
   $link
=mysql_connect('localhost''username''password');
   
mysql_select_db('database'$link);
   
$result mysql_query("SELECT * from prodotti ORDER BY Nome");
   if (
mysql_num_rows($result)) {
     echo 
"<table border=\"0\" width=\"100%\">";
     while (
$row=mysql_fetch_assoc($result))
       echo 
"<tr><td>".$row['Nome']."</td><td>".$row['Prezzo']."</td></tr>";
     echo 
"</table>";
   }
   
mysql_free_result($result);
   
mysql_close($link);
?>
</body>
</html>