Mejor tiempo circuito<->coche
Track :
".$nomcircuit.""; } ?>
Car :
>Brabham
>BRM
>Eagle
>Ferrari
>Honda
>Lotus
>Cooper
'' "; $sql2 = $sql2." and tempsqualif<>'No time' and voiture='".$voiture."' group by nomuser order by temps asc;"; $rs2 = mysql_query($sql2); $numlignes2 = mysql_num_rows($rs2); echo "
Best Qualification Times
"; echo "
Nombres de pilotes :".$numlignes2."
"; echo "
"; for ($i=0;$i<$numlignes2;$i++) { $row = mysql_fetch_array($rs2); echo "
"; echo "
".($i+1).".
"; echo "
"; echo stripslashes($row["nomuser"]); echo "
"; echo "
"; $tempsqualif = stripslashes($row["temps"]); echo $tempsqualif; echo "
"; echo "
"; } echo "
"; $sql2 = "select min(tempscourse) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur "; $sql2 = $sql2." where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$circuit."' "; $sql2 = $sql2." and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempscourse<>'' "; $sql2 = $sql2." and tempscourse<>'No time' and voiture='".$voiture."' group by nomuser order by temps asc;"; $rs2 = mysql_query($sql2); $numlignes2 = mysql_num_rows($rs2); echo "
Best Race Time
"; echo "
Nombres de pilotes :".$numlignes2."
"; echo "
"; for ($i=0;$i<$numlignes2;$i++) { $row = mysql_fetch_array($rs2); echo "
"; echo "
".($i+1).".
"; echo "
"; echo stripslashes($row["nomuser"]); echo "
"; echo "
"; $tempsqualif = stripslashes($row["temps"]); echo $tempsqualif; echo "
"; echo "
"; } echo "
"; } ?>