[insert_php]
// *************************************************************
// Da qui in poi le istruzioni seguenti devono esserci SEMPRE!!!
// *************************************************************
$servername = “hostingmysql01.register.it”;
$username = “SP4273_user”;
$password = “SPa92113”;
$dbname = “spiox_com_campionati”;// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
$strSQL = “SELECT * FROM Stagioni WHERE Ultima = -1;”;
$result = $conn->query($strSQL);

$rowStag = $result->fetch_assoc();
$Stag = $rowStag[“Stagione”];

// *************************************************************
// INSERIRE QUI SOTTO IL CODICE LEGA !!!!
// *************************************************************
$Lega = “0201”;
// *************************************************************
// =============================================================
// *************************************************************

// *************************************************************
// INSERIRE QUI SOTTO IL Tipo report: Risultati, Classifica, Tabellini, …
// *************************************************************

$headPage = “Classifica”;

// *************************************************************
// =============================================================
// *************************************************************

$strSQL = “SELECT ID_Lega FROM Squadre WHERE Stagione = ‘”.$Stag.”‘ AND ID_Squadra = ‘000814’ ORDER BY ID_Lega;”;
$result1 = $conn->query($strSQL);
if ($result1->num_rows > 0) {
$contenuto .=”

“;
echo $contenuto;

}
else
{
echo “nessuna lega trovata per la squadra 000814”;
}

$conn->close();
[/insert_php]