<?php
echo "<Table Width=\"90%\" Align=\"Center\" Cellpadding=\"3\" Cellspacing=\"1\">";

echo "<Tr>";
echo "<Td width=\"230px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "SQUADRA";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "PUN";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "GIO";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "VIN";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "PAR";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "PER";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "FAT";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "SUB";
echo "</Td>";
echo "<Td width=\"60px\" align=\"center\" bgcolor=\"#D9D9D9\">";
echo "DIF";
echo "</Td>";
echo "</Tr>";

$dbcnx = mysql_connect("$host", "$user_db", "$pass_db");
mysql_select_db("$nome_db", $dbcnx);
$res = mysql_query ('select * from clas2010 ORDER BY punti DESC, differenza DESC, squadra');
$num = mysql_num_rows ($res);
for ($i=0; $i<$num; $i++)
{
$td1 = mysql_result ($res, $i, "squadra");
$td3 = mysql_result ($res, $i, "giocate");
$td4 = mysql_result ($res, $i, "vinte");
$td5 = mysql_result ($res, $i, "pareggiate");
$td6 = mysql_result ($res, $i, "perse");
$td7 = mysql_result ($res, $i, "fatti");
$td8 = mysql_result ($res, $i, "subiti");
$td9 = mysql_result ($res, $i, "punti");
$td1strip = stripslashes($td1);

if (($i % 2) == 0)
$color = "#EEEEEE";
else
$color = "#D9D9D9";

if ($td1strip == "nome squadra ") $color = "#FF0000";

echo "<Tr>";
echo "<Td class=\"style10\" align=\"left\" bgcolor=\"$color\">";
echo "<a href=\"partite2010.php?squadra=$td1strip\" title=\"Tutti i risultati\">$td1strip</a>";
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td9;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td3;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td4;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td5;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td6;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td7;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td8;
echo "</Td>";

echo "<Td class=\"style10\" align=\"center\" bgcolor=\"$color\">";
echo $td7-$td8;
echo "</Td>";
echo "</Tr>";


}

mysql_close($dbcnx);
?>
</Table>