title: mysql: select last 10 rows from DESC LIMIT
body: <p>i'm working on a block which will display last 10 posts, when user clicks on "load more" button i would like to display 10 older posts.</p>
  
  <p>how can i select last 10 rows if i'm already using DESC LIMIT?</p>
  
  <pre><code>mysql_query("SELECT title,id,alt_name FROM dle_post WHERE approve='1' AND date &gt;= '$monthagodate'
  AND date &lt; '$curdate' + INTERVAL 1 day ORDER BY date DESC LIMIT $more;");
  </code></pre>