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.

So the query I'm considering running will look something like this: 

```
$result = mysql_query("SELECT * 
                         FROM links 
                     ORDER BY date DESC 
                        WHERE date < '$olderdate' 
                        LIMIT 9"); 

```

will this work? or is there a better way of pulling this off?