<?php
$stampa = "SELECT * FROM sfide ORDER BY id ASC";
$query = mysql_query ($stampa,$db) or die ("Non riesco ad eseguire la richiesta $stampa");
echo "<table width=\"100%\" border=\"0\">\n";
while($Row = mysql_fetch_array($query)) {
echo "<tr>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['day']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['mes']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['yea']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['clan1']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['clan2']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['ladder']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['result1']. "</font></td>\n";
echo "<td width=\"100%\"><p align=\"left\">
<font face=\"Tahoma\" size=\"2\" color=\"#336600\">" .$Row['result2']. "</font></td>\n";
echo "</tr>\n";
}
echo "</table>\n";
mysql_close($db);
?>