Strange Query Error...

From: Date: Sat, 27 Nov 2010 17:30:12 +0000
Subject: Strange Query Error...
Groups: php.general 
Request: Send a blank email to php-general+get-309712@lists.php.net to get a copy of this message
Hi gang, I am executing a query via PHP that gives me a PHP error: 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 'AND m.Preferred_First_Name LIKE 'Don' AND m.Preferred_Last_Name LIKE 'Wielan' at line 1 but when I copy the ECHO of the select query and run it in Sequel Pro Query, it returns no error. Here is the query: select m.* from Members m inner join Member_Years my on m.aucciim_id = my.member_id where now() < DATE_ADD(DATE_SUB(concat(member_year + 1,'-07-01'), INTERVAL 1 DAY), INTERVAL 30 DAY) AND m.Preferred_First_Name LIKE 'Don' AND m.Preferred_Last_Name LIKE 'Wieland' group by m.AUCCIIM_ID order by m.preferred_last_name What is causing it to choke via PHP? Thanks! Don

« previous php.general (#309712) next »