1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| $date = date('Y');
$sql = "select MIN(meiltemps)as nombre, pist from toptemps where date='$date' group by pist";
$req = $db->query($sql);
echo "<br /><br /><h1>Meilleurs <img src='images/chronom.png' alt='Icone chrono' id='test' /> $date</h1><br />";
echo "<center><table width='80%' background='themes/mx-mysticjade/images/toolbar-bg.png' border='1' class='td2'><tr>
<td width='30%'><enter>Piste</center></td>
<td width='20%'><center>Pilote</center></td>
<td width='30%'><center>Voiture</center></td>
<td><center>Meilleur temps</center></td></tr></table></center>";
while($row = $req->fetch()){
$nombre = $row['nombre'];
}
$sql2 = "select pist,car,meiltemps,pil,prenom from toptemps where date='$date' order by pist,meiltemps ASC";
$req2 = $db->query($sql2);
$i=0;
$values[0]="#515151";
$values[1]="#212121";
while($row = $req2->fetch()){
$bgcolor=$values[$i % 2 ];
$temps2 = $row['meiltemps'];
if($temps2<=$nombre){$coul = "#FF6600";}
elseif($temps2>=$nombre){$coul = " ";}
echo "<center><table width='80%' border='0' bgcolor='$bgcolor'><tr>
<td width='30%'>".$row['pist']."</td>
<td width='20%'><center>".$row['pil']." ".$row['prenom']."</center></td>
<td width='30%'><center>".$row['car']."</center></td>
<td bgcolor='$coul'><center>".$row['meiltemps']."</center></td></tr></table></center>";
$i++;
} |