1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| $sql = "SELECT * FROM gghf_distance WHERE rando='$rand' AND annee= '$time' ORDER BY distance DESC";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$total = mysql_num_rows($req);
?>
<table style="width:100%" cellpadding="0" cellspacing="">
<tr>
<td>
Distances
</td>
<td>
Total
</td>
</tr>
<?php
while($data = mysql_fetch_assoc($req))
{
echo '<tr><td>'.$data['distance'].'</td>';
echo '<td>'.$total.'</td></tr>';
} |