dealing with dates in mysql?

[Micamu]

i have this long mysql query, and im trying to find fetch the rows that are older then the given date \[code\]$lastmsg\[/code\].this is the code im using:\[code\]$result="SELECT u.username, u.picture,m.id, m.user_note, m.reply_id, m.reply_name, m.recycle_id, m.recycle_name, m.dt FROM relationships r, notes m, user u WHERE m.user_id = r.leader AND r.leader = u.user_id AND r.listener = ".$_SESSION['user_id']." UNION select username, picture,id, user_note, reply_id, reply_name, recycle_id, recycle_name, dt from user u, notes b where u.user_id = b.user_id AND b.user_id =".$_SESSION['user_id']." AND WHERE dt < '$lastmsg' ORDER BY dt DESC LIMIT 10";mysql_query($result) or die(mysql_error().$result);\[/code\]sorry about the long messy code, the query worked until i added this $lastmsg where clause.p.s. dt is \[code\]DATETIME\[/code\] and $lastmsg is \[code\]2010-09-20 12:53:43\[/code\]the error im getting is:\[code\]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where dt <'2010-09-20 12:53:43' ORDER BY dt DESC LIMIT 10' at line 20SELECT u.username, u.picture,m.id, m.user_note, m.reply_id, m.reply_name, m.recycle_id, m.recycle_name, m.dt FROM relationships r, notes m, user u WHERE m.user_id = r.leader AND r.leader = u.user_id AND r.listener = 2 UNION select username, picture,id, user_note, reply_id, reply_name, recycle_id, recycle_name, dt from user u, notes b where u.user_id = b.user_id and b.user_id =2 and where dt <'2010-09-20 12:53:43' ORDER BY dt DESC LIMIT 10\[/code\]