Statistiques serveur
"; $sql = "select (sum(distancequalif)+sum(distancecourse))/1000 as Res,Nom from tbl_resultat,tbl_course,tbl_circuit where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit=tbl_circuit.idcircuit group by Nom order by Res DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo "
| ".($i+1).". | "; echo ""; echo stripslashes($row["Nom"]); echo " | "; echo "";
$distance = stripslashes($row["Res"]);
if ($i==0)
{
$max = $distance;
}
$pixel = ($distance/$max)* 450;
$pixel = abs($pixel)."px";
$hauteur = "8px";
echo " ";
echo " | ";
echo ""; echo $distance; echo " kms. | "; echo "