On 2010-11-27, at 12:30 PM, Don Wieland <d...@dwdataconcepts.com> wrote:
> 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 Try removing the backticks around the table names. If you do use them, then all values (field names and table names) need it. Bastien Koert Sent from my iPhone -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
