THESE FAST 10'S ARE RAN ON JR'S SERVERS, 41, 42, AND 43!
{source}
<?php
mysql_connect('localhost', 'teamvlr', 'b3VoaI32983eJOEe78hdf') || die('Could not connect: '.mysql_error());
mysql_select_db('teamvlr_dtr2') || die('Could not select database: '.mysql_error());
$res_track = mysql_query('SELECT track FROM j25_tnl GROUP BY track ORDER BY track ASC');
while ( ( $row_track = mysql_fetch_row($res_track) ) ) {
$res_speed = mysql_query("SELECT player, min(speed) as speed, min(`time`) as total FROM j25_tnl WHERE track='".mysql_real_escape_string($row_track[0])."' GROUP BY player ORDER BY speed, total ASC");
if ( mysql_num_rows($res_speed) == 0 ) continue;
echo '<table class="zebra" width="50%" border="1"><caption align="top" class="track">'.$row_track[0].'</caption><tbody>'.
'<tr class="header"><th align="left">Pos</th><th align="left">Driver</th><th align="left">Time</th><th align="left">Total Race Time</th></tr>';
$i = 1;
while ( ( $row_speed = mysql_fetch_assoc($res_speed) ) ) {
echo '<tr class="detailodd"><td>'.$i.'</td><td>'.$row_speed['player'].'</td><td>'.$row_speed['speed'].'</td><td>'.$row_speed['total'].'</td></tr>';
$i++;
}
echo '</tbody></table><br />';
}
mysql_close();
?>
{/source}