have you tried testing the recordset in the recordset window?
have you tried the query in the MySQL GUI Tool?
if you can test the recordset in the recordset window, then the syntax error is coming from something else on the page.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.