title: Get a rank, based on score, from an unordered MySql Database when given a Username
body: <p>Okay so I have a table that has the following</p>
  
  <pre><code>KEY   username   password   score  
  </code></pre>
  
  <p>The above columns are not in any specific order.</p>
  
  <p>I want to send my Database a username and have it send me back what rank that user name is based on its score. So for example if I had 10 people in there and the 3rd person in has the highest score. When I pass the 3rd persons username in I want it to send back 1.</p>
  
  <p>Is this possible? </p>
  
  <p>I have been trying things like this</p>
  
  <pre><code>$result = mysql_query("SELECT * FROM tablename where username='$username' ORDER BY score DESC");
  </code></pre>
  
  <p>but it doesnt seem to give me the row number </p>