title: Display the numerical index order of results in mySQL as a additional column
body: <p>First q ever Whohoo!</p>
  
  <p>I have a mySQL table with data</p>
  
  <pre><code>**username**   **score**   
  Count Joe         278     
  Count Joe         255
  Count Joe         298
  Count Joe         289
  </code></pre>
  
  <p>I am having problems displaying the following result set:</p>
  
  <pre><code>**RANK** **USERNAME** **SCORE**
  1 Count Joe 255
  2 Count Joe 278
  3 Count Joe 289
  4 Count Joe 298
  </code></pre>
  
  <p>Currently it is returning</p>
  
  <pre><code>**RANK** **USERNAME** **SCORE**
      1 Count Joe 255
      22 Count Joe 278
      32 Count Joe 289
      18 Count Joe 298
  </code></pre>
  
  <p>Using</p>
  
  <p><code>SET @ROW=0;
  SELECT @ROW:=@ROW + 1 AS rank, username, total FROM game_scores GROUP BY username ORDER BY total ASC LIMIT 10
  </code></p>
  
  <p>The query above seems to return the index position or the user within the queried table.</p>