title: MySQL order by two values
body: <p>In short, I have a game of sorts, and the score board for it shows the score of the player at the end + how long they took to achieve it. I need to order my MySQL results so that the highest score in the fastest time is first and the lowest score with the slowest time is last, and everything in between is ranked in the same way. But I have no idea how I'd do that, here's my sql as it stands:</p>
  
  <pre><code>$sql1 = "SELECT * FROM boobmatch_highscores ORDER BY t_score DESC, time ASC";
  </code></pre>
  
  <p>Any help would be greatly appreciated!</p>
  
  <p>The data in the table:</p>
  
  <pre><code>Score       Time
  23        00:04:32
  23        00:04:31
  25        00:02:32
  16        00:06:32
  35        00:04:32
  2         00:01:17
  -13       00:19:32
  -3        00:07:27
  </code></pre>