rankings.php

<?php
session_start();
include("header.php");
if(!isset($_SESSION['uid'])) {
  echo "You must be logged in to view this page";
}else{
  ?>
  <center><h2>Battle Players</h2></center>
  <br />
  <table cellpadding="2" cellspacing="2">
    <tr>
      <td width="50px"><b>Rank</b></td>
      <td width="150px"><b>Username</b></td>
      <td width="200px"><b>Gold</b></td>
    </tr>
    <?php
    $get_users = mysql_query("SELECT `id`,`overall` FROM `ranking` WHERE `overall`>'0' ORDER BY `overall` ASC") or die(mysql_error());
    while($row = mysql_fetch_assoc($get_users)) { var_dump($row)
    echo "<tr>";
    echo "<td>". $row['overall']. "</td>";
    $get_user = mysql_query("SELECT `username` FROM `user` WHERE `id`='".$row['id']."'") or die(mysql_error());
    $rank_name = mysql_fetch_assoc($get_user);
    echo "<td><a href=\"stats.php?id=" .$row['id']."\">" . $rank_name['username'] . "</a></td>";
    $get_gold = mysql_query("SELECT `gold` FROM `stats` WHERE `id`='".$row['id']."'") or die(mysql_error());
    $rank_gold = mysql_fetch_assoc($get_gold);
    echo "<td>" . number_format($rank_gold['gold']) . "</td>";
    echo "</tr>";
    }
    ?>
  </table>
  <?php
}
include("footer.php");
?>