rendered paste body<?
include"db.php" ;
echo ('
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="38"><div align="left"><strong>Racer</strong></div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Apr 04</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Apr 11</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Apr 18</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Apr 25</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>May 02</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>May 09</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>May 16</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>May 23</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>May 30</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jun 06</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jun 13</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jun 20</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jun 27</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jul 04</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jul 11</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jul 18</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Jul 25</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Aug 01</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Aug 08</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Aug 15</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Aug 22</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Aug 29</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Sep 05</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Sep 12</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Sep 19</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Sep 26</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Oct 03</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Oct 10</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Oct 17</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Oct 24</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Oct 31</strong></div>
</div></td>
<td><div style="writing-mode: tb-rl; filter: FlipH FlipV;">
<div align="left"><strong>Total</strong></div>
</div></td> </tr>
');
$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('
<tr>
<td height="38">'.$racer.'</td>
<td>'.$race1.'</td>
<td>'.$race2.'</td>
<td>'.$race3.'</td>
<td>'.$race4.'</td>
<td>'.$race5.'</td>
<td>'.$race6.'</td>
<td>'.$race7.'</td>
<td>'.$race8.'</td>
<td>'.$race9.'</td>
<td>'.$race10.'</td>
<td>'.$race11.'</td>
<td>'.$race12.'</td>
<td>'.$race13.'</td>
<td>'.$race14.'</td>
<td>'.$race15.'</td>
<td>'.$race16.'</td>
<td>'.$race17.'</td>
<td>'.$race18.'</td>
<td>'.$race19.'</td>
<td>'.$race20.'</td>
<td>'.$race21.'</td>
<td>'.$race22.'</td>
<td>'.$race23.'</td>
<td>'.$race24.'</td>
<td>'.$race25.'</td>
<td>'.$race26.'</td>
<td>'.$race27.'</td>
<td>'.$race28.'</td>
<td>'.$race29.'</td>
<td>'.$race30.'</td>
<td>'.$race31.'</td>
<td>'.$total.'</td>
</tr>
');
$i++;
}
echo '</table>';
mysql_close($connection);
?>