title: sql order by date before selection query help
body: <p>I'm about to jump into some SQL query code that I haven't attempted before, basically my tables will have rows with dates that will not be in order, what I want to do is firstly order the table by date, then select 9 rows that will be older than a specified date.</p>
  
  <p>So the query I'm considering running will look something like this: </p>
  
  <pre><code>$result = mysql_query("SELECT * 
                           FROM links 
                       ORDER BY date DESC 
                          WHERE date &lt; '$olderdate' 
                          LIMIT 9"); 
  </code></pre>
  
  <p>will this work? or is there a better way of pulling this off? </p>