result.php

<html>
<?php
echo "<h2>Lista Autori</h2>";
echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>";
echo "<tr style='font-weight: bold;'>";
echo "<td width='auto' >&nbsp;Autore</td>";
echo "<td width='auto' >&nbsp;Titolo</td>";
echo "</tr>";
	//1. Connessione al Database
$connection = mysql_connect("localhost","root","");
if(!$connection){
	die("Database connection failed: " . mysql_error());
}
	//2. Seleziona Database
$db_select = mysql_select_db("forms1",$connection);
if (!$db_select) {
	die("Database connection failed: " . mysql_error());
}
	//3. Interroga Database

$result = mysql_query("SELECT * FROM demo ORDER BY Autore, Titolo", $connection);

if (!$result) {
	die("Database query failed: " . mysql_error());
}

	//4. Use Returned Data
while ($row = mysql_fetch_array($result))
	{

	echo "<tr>";
	echo "<td width='auto'>" . "&nbsp;"  . $row[1] . "&nbsp;" . "</td>";
	echo "<td width='auto'>" . "&nbsp;" . $row[2] . "&nbsp;" . "</td>";
	echo "</tr>";

	}

mysql_close($connection);
?>
</html>