PHPList integration to OsCommerce in General Add-Ons Support Posted July 1, 2006 1064 - 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 '-_phplist.phplist_user_user where email = 'firstname.lastname@example.org'' at line 1 select id, email, foreignkey from rocketz_net_-_phplist.phplist_user_user where email = 'email@example.com' Hmm...syntax error.... can someone suggest me where to look for?? james Hi James, This seems to be a database name problem, are you sure your database name is 'rocketz_net_-_phplist'? Isn't it possible it should be 'rocketz_net_phplist' instead? I think the sytax error is reffering to the '-'-sign, this sign is probably not allowed in mysql naming conventions. Regards Thomas A.