Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › exporting doesnt work for one site but does for another

View all replies to this thread

exporting doesnt work for one site but does for another

Thread began 5/24/2016 2:34 pm by Christopher West | Last modified 5/25/2016 8:37 pm by Christopher West | 2915 views | 4 replies

5/25/2016 5:04 pmChristopher WestCommunity Expert

ok I got it working, but the SQL is throwing out syntax errors on some of my queries. for example:

$rows->setQuery("SELECT * FROM newsletter WHERE NewsLetterOptIn = 1 AND NewsLetterEmail IN (SELECT OrderBuyerEmail FROM `orders` WHERE OrderCouponCode != "")");

This is the error: Parse error: syntax error, unexpected '")"' (T_CONSTANT_ENCAPSED_STRING) in /homepages/41/d416416140/htdocs/admin/exports/export-voucher-customers.php on line 10

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.