title: MYSQL Select from table, get newest/last 10 rows in table
body: <p>What's the best, and easiest way to do this?  My query currently is:</p>
  
  <pre><code>  SELECT * 
      FROM chat 
     WHERE (userID = $session AND toID = $friendID) 
        OR (userID = $friendID AND toID = $session) 
  ORDER BY id 
     LIMIT 10
  </code></pre>
  
  <p>This shows the first 10 rows though, not the last 10.</p>
  
  <p>EDIT: I Want the last 10 rows (Which yes, DESC does this) However I want them to be returned in ASCENDING order.</p>