highest20.php

   1 <?php include ("config.php");
   2 $sql = "SELECT * FROM users ORDER BY cookies DESC";
   3 $result = mysql_query($sql);
   4 echo "<table width=100%><tr><td><b>Username</td><td><b>Aura</td></tr>";
   5 $num = 0;
   6 while ($myrow = mysql_fetch_array($result))
   7 {
   8         if ($num < 20)
   9         {
  10                 $num = $num +1;
  11                 echo "<tr><td>".$num.". ".$myrow["username"]."</td><td>".$myrow["cookies"]."</td></tr>";
  12         }
  13 }
  14 echo "</table>";
  15 ?>