Ranking table not working #2
<p><strong>First of all I already asked this question and got one bit fixed but the other isnt fixed yet so I ask once more</strong></p>

<p>I'm working on a game and I'm trying to get a ranking table, I have the code for it from a youtube video but It's not working. here is the video <a href="http://www.youtube.com/watch?v=SlCllEung8A" rel="nofollow">simple strategy game</a> so I dont want to change from him. The problem is it only shows the header names and it wont show the rows with the usernames and ids and ranks etc..</p>

<p>Here is the code</p>

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