title: Creating MySQL leaderboard
body: <p>I'm trying to make a leaderboard made out of MySQL data. The MySQL data comes from a plugin on a minecraft server. So I linked the plugin's data to a MySQL database, called iConomy</p>
  
  <p>In the database I made 2 tables atm: iconomy and bitcoin</p>
  
  <p>The meaning is that a leaderboard would be displayed on the website as:</p>
  
  <pre><code>Rank Number | Username | Bitcoin | Balance
  1.          |Nicolas   | xxxxxxx | 1500
  </code></pre>
  
  <p>So 1 would be the rank number, Nicolas my username, bitcoin my bitcoin adress. And balance my current money in game. That data gets provided by the plugin that I succesfully linked into the MySQL database that I mentioned.    </p>
  
  <p>Reading through a few posts and copying a bit of code, I came to this php code:</p>
  
  <pre><code> &lt;?php
  
      $result = mysql_query("SELECT username, balance, adress FROM iconomy, bitcoin ORDER BY balance DESC");
      $rank = 1;
  
      if (mysql_num_rows($result)) {
          while ($row = mysql_fetch_assoc($result)) {
              echo "&lt;td&gt;{$rank}&lt;/td&gt;
                    &lt;td&gt;{$row['username']}&lt;/td&gt;
                    &lt;td&gt;{$row['balance']}&lt;/td&gt;
                    &lt;td&gt;{$row['adress']}&lt;/td&gt;";
  
              $rank++;
          }
      }
  ?&gt;   
  </code></pre>
  
  <p>So as you can see i have the username, balance, adress which i get from the tables iconomy and bitcoin (thats where the adresses would be stored).</p>
  
  <p>I don't know if this code is right, thats why I came posting here.</p>
  
  <p>But if it is (this will sound stupid), how do i make a decent webpage of it.</p>
  
  <p>How do I succesfully link that php file into a webpage?</p>