Mejor tiempo de cualificación

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i=0;$i<$numlignes;$i++) { $row = mysql_fetch_array($rs); $id = stripslashes($row["Id"]); $nom = stripslashes($row["Nom"]); echo ""; echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='Brabham' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='Cooper' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='Ferrari' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='Honda' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='Lotus' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='Eagle' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; $sql2 = "select min(tempsqualif) as temps,nomuser from tbl_resultat,tbl_course,tbl_utilisateur where tbl_resultat.idcourse=tbl_course.idcourse and tbl_course.idcircuit='".$id."' and tbl_resultat.idpilote = tbl_utilisateur.iduser and tempsqualif<>'' and tempsqualif<>'No time' and voiture='BRM' group by nomuser order by temps asc;"; $query2 = $sql2; $rs2 = mysql_query($query2); $numlignes2 = mysql_num_rows($rs2); if ($numlignes2>0) { $row2 = mysql_fetch_array($rs2); $temps = stripslashes($row2["temps"]); $pilote = stripslashes($row2["nomuser"]); } else { $temps = 'No Time'; $pilote = ''; } echo ""; echo ""; } echo "

Circuit	Brabham	Cooper	Ferrari	Honda	Lotus	Eagle	BRM
".$nom."	"; echo $temps.' '.$pilote; echo "	"; echo $temps.' '.$pilote; echo "	"; echo $temps.' '.$pilote; echo "	"; echo $temps.' '.$pilote; echo "	"; echo $temps.' '.$pilote; echo "	"; echo $temps.' '.$pilote; echo "	"; echo $temps.' '.$pilote; echo "

"; ?>