Estadistica podiums por pilotos

"; $sql = "select count(idcourse) as nbresult, nomuser from tbl_resultat,tbl_utilisateur where tbl_resultat.idpilote=tbl_utilisateur.iduser and (tbl_resultat.course<>'' and tbl_resultat.course is not null) and nomuser<>'GPLE Gaiztor' and (tbl_resultat.course='1' or tbl_resultat.course='2' or tbl_resultat.course='3') and tbl_resultat.tempscourse<>'No Time' group by nomuser order by nbresult DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo ""; for ($i=0;$i<$numlignes;$i++) { $row = mysql_fetch_array($rs); echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".($i+1).".

"; $driver = stripslashes($row["nomuser"]); echo $driver; echo "

"; $nbcourse = stripslashes($row["nbresult"]); echo $nbcourse; echo "

"; echo "Victorias"; echo "
"; $sql = "select count(idcourse) as nbresult, nomuser from tbl_resultat,tbl_utilisateur where tbl_resultat.idpilote=tbl_utilisateur.iduser and (tbl_resultat.course<>'' and tbl_resultat.course is not null) and nomuser<>'GPLE Gaiztor' and tbl_resultat.course='1' and tbl_resultat.tempscourse<>'No Time' group by nomuser order by nbresult DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo ""; for ($i=0;$i<$numlignes;$i++) { $row = mysql_fetch_array($rs); echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".($i+1).".

"; $driver = stripslashes($row["nomuser"]); echo $driver; echo "

"; $nbcourse = stripslashes($row["nbresult"]); echo $nbcourse; echo "

"; echo "Segundos"; echo "
"; $sql = "select count(idcourse) as nbresult, nomuser from tbl_resultat,tbl_utilisateur where tbl_resultat.idpilote=tbl_utilisateur.iduser and (tbl_resultat.course<>'' and tbl_resultat.course is not null) and nomuser<>'GPLE Gaiztor' and tbl_resultat.course='2' and tbl_resultat.tempscourse<>'No Time' group by nomuser order by nbresult DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo ""; for ($i=0;$i<$numlignes;$i++) { $row = mysql_fetch_array($rs); echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".($i+1).".

"; $driver = stripslashes($row["nomuser"]); echo $driver; echo "

"; $nbcourse = stripslashes($row["nbresult"]); echo $nbcourse; echo "

"; echo "Terceros"; echo "
"; $sql = "select count(idcourse) as nbresult, nomuser from tbl_resultat,tbl_utilisateur where tbl_resultat.idpilote=tbl_utilisateur.iduser and (tbl_resultat.course<>'' and tbl_resultat.course is not null) and nomuser<>'GPLE Gaiztor' and tbl_resultat.course='3' and tbl_resultat.tempscourse<>'No Time' group by nomuser order by nbresult DESC;"; $query = $sql; $rs = mysql_query($query); $numlignes = mysql_num_rows($rs); $max=0; echo ""; for ($i=0;$i<$numlignes;$i++) { $row = mysql_fetch_array($rs); echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".($i+1).".

"; $driver = stripslashes($row["nomuser"]); echo $driver; echo "

"; $nbcourse = stripslashes($row["nbresult"]); echo $nbcourse; echo "

"; ?>