include"db.php" ;
echo ('
Racer |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
');
$query="SELECT * FROM `stats` ORDER BY total DESC";
$result=mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$id = htmlentities(mysql_result($result,$i,"id"));
$racer = htmlentities(mysql_result($result,$i,"racer"));
$race1 = htmlentities(mysql_result($result,$i,"race1"));
$race2 = htmlentities(mysql_result($result,$i,"race2"));
$race3 = htmlentities(mysql_result($result,$i,"race3"));
$race4 = htmlentities(mysql_result($result,$i,"race4"));
$race5 = htmlentities(mysql_result($result,$i,"race5"));
$race6 = htmlentities(mysql_result($result,$i,"race6"));
$race7 = htmlentities(mysql_result($result,$i,"race7"));
$race8 = htmlentities(mysql_result($result,$i,"race8"));
$race9 = htmlentities(mysql_result($result,$i,"race9"));
$race10 = htmlentities(mysql_result($result,$i,"race10"));
$race11 = htmlentities(mysql_result($result,$i,"race11"));
$race12 = htmlentities(mysql_result($result,$i,"race12"));
$race13 = htmlentities(mysql_result($result,$i,"race13"));
$race14 = htmlentities(mysql_result($result,$i,"race14"));
$race15 = htmlentities(mysql_result($result,$i,"race15"));
$race16 = htmlentities(mysql_result($result,$i,"race16"));
$race17 = htmlentities(mysql_result($result,$i,"race17"));
$race18 = htmlentities(mysql_result($result,$i,"race18"));
$race19 = htmlentities(mysql_result($result,$i,"race19"));
$race20 = htmlentities(mysql_result($result,$i,"race20"));
$race21 = htmlentities(mysql_result($result,$i,"race21"));
$race22 = htmlentities(mysql_result($result,$i,"race22"));
$race23 = htmlentities(mysql_result($result,$i,"race23"));
$race24 = htmlentities(mysql_result($result,$i,"race24"));
$race25 = htmlentities(mysql_result($result,$i,"race25"));
$race26 = htmlentities(mysql_result($result,$i,"race26"));
$race27 = htmlentities(mysql_result($result,$i,"race27"));
$race28 = htmlentities(mysql_result($result,$i,"race28"));
$race29 = htmlentities(mysql_result($result,$i,"race29"));
$race30 = htmlentities(mysql_result($result,$i,"race30"));
$race31 = htmlentities(mysql_result($result,$i,"race31"));
$total = htmlentities(mysql_result($result,$i,"total"));
echo('
| '.$racer.' |
'.$race1.' |
'.$race2.' |
'.$race3.' |
'.$race4.' |
'.$race5.' |
'.$race6.' |
'.$race7.' |
'.$race8.' |
'.$race9.' |
'.$race10.' |
'.$race11.' |
'.$race12.' |
'.$race13.' |
'.$race14.' |
'.$race15.' |
'.$race16.' |
'.$race17.' |
'.$race18.' |
'.$race19.' |
'.$race20.' |
'.$race21.' |
'.$race22.' |
'.$race23.' |
'.$race24.' |
'.$race25.' |
'.$race26.' |
'.$race27.' |
'.$race28.' |
'.$race29.' |
'.$race30.' |
'.$race31.' |
'.$total.' |
');
$i++;
}
echo '
';
mysql_close($connection);
?>