require("config.php");
?>
stat serveur
Statistiques serveur
// récupération du classement pilotes
$id = $HTTP_GET_VARS["id"];
$sql = "select NomUser,Nationalite,Nom,DateCourse,Voiture,tempsqualif,tempscourse,qualification,course from tbl_resultat,tbl_course,tbl_circuit,tbl_utilisateur where idpilote='".$id."' and tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit=tbl_circuit.idcircuit and tbl_resultat.idpilote=tbl_utilisateur.iduser group by tbl_resultat.idcourse order by course desc;";
$query = $sql;
$rs = mysql_query($query);
$numlignes = mysql_num_rows($rs);
echo "";
echo "";
echo "Name | ";
echo "Nationality | ";
echo "Track | ";
echo "Date | ";
echo "Car | ";
echo "Qualif. Time | ";
echo "Race Time | ";
echo "Qualification | ";
echo "Race | ";
echo "
";
for ($i=0;$i<$numlignes;$i++)
{
$row = mysql_fetch_array($rs);
echo "";
echo "".$row["NomUser"]." | ";
echo "".$row["Nationalite"]." | ";
echo "".$row["Nom"]." | ";
echo "".$row["DateCourse"]." | ";
echo "".$row["Voiture"]." | ";
echo "".$row["tempsqualif"]." | ";
echo "".$row["tempscourse"]." | ";
echo "".$row["qualification"]." | ";
echo "".$row["course"]." | ";
echo "
";
}
echo "
";
?>