Re: Strange Query Error...

On Sat, Nov 27, 2010 at 12:30, Don Wieland <donw@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? This is actually better-suited to the DB list (CC'd) than the General list, but one primary question: are you using the mysql_* family, mysqli_* family, or another method of interfacing with MySQL? -- </Daniel P. Brown> Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting (866-) 725-4321 http://www.parasane.net/