BotT Rookie – Classifica

[insert_php]
$var1=’rookie’;$var2=2017;
require_once(“appoggio17/conn.inc.php”);
$sql = “select * from “.$var1.”_”.$var2.” order by tot desc”;
$req = mysql_query($sql);
$res = mysql_num_rows($req);
if (mysql_errno())
die(“Errore n: “.mysql_errno().” Descr.: “.mysql_error().” “);
if ($res == 0)
die(“Dati non disponibili”);

//echo “

Battle of the Twins “.$var2.”

“;
echo”

“;

while($row = mysql_fetch_array($req))
{

$sql1 = “select * from iscritti_”.$var2.” where tab = “.$row[‘tab’].” “;
$req1 = mysql_query($sql1);
$res1 = mysql_num_rows($req1);
if (mysql_errno())
die(“Errore n: “.mysql_errno().” Descr.: “.mysql_error().” “);

echo”

“;

while($row1 = mysql_fetch_array($req1))
{
if($row1[‘wild’]==1)
{
echo “

“;
echo “

“;
echo “

“;
$g=$row[‘g1’]+$row[‘g2’]+$row[‘g3’]+$row[‘g4’]+$row[‘g5’];
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
}
echo”

#”. $row[‘tab’].” “. $row[‘cognome’].” “;
}
else
{
echo “

#“. $row[‘tab’].” “. $row[‘cognome’].” “;
}
}

//echo “

“. $row[‘cognome’].” “;
echo “”. $row[‘nome’].”
“.$row[‘g1’].” “.$row[‘g2’].” “.$row[‘g3’].” “.$row[‘g4’].” “.$row[‘g5’].” “.$row[‘g6’].” “.$g.”

“;
[/insert_php]