'' and tempsqualif<>'No time' group by nomuser,voiture order by temps asc"; echo ""; echo $id; echo ""; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); echo "
Meilleurs temps de qualif
"; echo "
Nombres de pilotes :".$numlignes."
"; echo "
| ".($i+1).". | "; echo ""; echo stripslashes($row["nomuser"]); echo " | "; echo ""; $voiture = stripslashes($row["voiture"]); echo $voiture; echo " | "; echo ""; $tempsqualif = stripslashes($row["temps"]); echo $tempsqualif; echo " | "; echo "
Meilleurs temps courses ".$id."
"; echo "
Nombres de pilotes :".$numlignes."
"; echo "
| ".($i+1).". | "; echo ""; echo stripslashes($row["nomuser"]); echo " | "; echo ""; $voiture = stripslashes($row["voiture"]); echo $voiture; echo " | "; echo ""; $tempscourse = stripslashes($row["temps"]); echo $tempscourse; echo " | "; echo "
Distance parcourues en qualifs
"; echo "
Nombres de pilotes :".$numlignes."
"; echo "
| ".($i+1).". | "; echo ""; echo stripslashes($row["nomuser"]); echo " | "; echo "";
$distance = stripslashes($row["distance"]);
if ($i==0)
{
$max = $distance;
}
$pixel = ($distance/$max)* 450;
$pixel = abs($pixel)."px";
$hauteur = "8px";
echo " ";
echo " | ";
echo ""; echo $distance; echo "km."; echo " | "; echo "
Distance parcourues en courses
"; echo "
Nombres de pilotes :".$numlignes."
"; echo "
| ".($i+1).". | "; echo ""; echo stripslashes($row["nomuser"]); echo " | "; echo "";
$distance = stripslashes($row["distance"]);
if ($i==0)
{
$max = $distance;
}
$pixel = ($distance/$max)* 450;
$pixel = abs($pixel)."px";
$hauteur = "8px";
echo "";
echo " | ";
echo ""; echo $distance; echo "km."; echo " | "; echo "
"; echo "Race Distance by Car"; echo "
"; $sql = "select sum(distancecourse)/1000 as Res , Voiture from tbl_resultat,tbl_course where tbl_course.idcourse=tbl_resultat.idcourse and tbl_course.idcircuit='".$id."' group by voiture order by Res DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo "
| ".($i+1).". | "; echo ""; $voiture = stripslashes($row["Voiture"]); if ($voiture=='Eagle') { $voiture = 'Brabham BT7'; } if ($voiture=='Brabham') { $voiture = 'Brabham BT11'; } echo $voiture; 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 "
"; echo "Qualify Distance by Car"; echo "
"; $sql = "select sum(distancequalif)/1000 as Res , Voiture from tbl_resultat,tbl_course where tbl_course.idcourse=tbl_resultat.idcourse and tbl_course.idcircuit='".$id."' group by voiture order by Res DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo "
| ".($i+1).". | "; echo ""; $voiture = stripslashes($row["Voiture"]); if ($voiture=='Eagle') { $voiture = 'Brabham BT7'; } if ($voiture=='Brabham') { $voiture = 'Brabham BT11'; } echo $voiture; 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 "