title: Inserting data in the correct spot in a sorted mySQL table, via php/android
body: <p>I have found a ton of information on this subject, but its overload. I can't seem to find exactly the solution I am looking for, all I find is general stuff.</p>
  
  <p>I have a mySQL table setup like this: rank | name | score</p>
  
  <p>The android application only knows the name and score when inserting. I use php, and httppost to insert the data. I know how to do that. What I want to do is insert the data based on the score and have the rank assigned automatically also based on the score.</p>
  
  <p>Say I have these values already in the database:</p>
  
  <ol>
  <li>Tiff 1000</li>
  <li>Allen 800</li>
  </ol>
  
  <p>and I want to insert the values "Jake 900"</p>
  
  <p>How do I get the resulting table to be:</p>
  
  <ol>
  <li>Tiff 1000</li>
  <li>Jake 900</li>
  <li>Allen 800</li>
  </ol>
  
  <p>Preferably I don't want the phone or tablet to be the thing sorting the data, because I know how to download the table, insert the info, resort it, and upload again, but I don't want the service hanging for a while even if it  is in the background.</p>
  
  <p>Solutions?</p>