Re: Strange Query Error...
| From: | Don Wieland | Date: | Sat, 27 Nov 2010 18:18:12 +0000 |
| Subject: | Re: Strange Query Error... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-309720@lists.php.net to get a copy of this message | ||
On Nov 27, 2010, at 10:07 AM, Bastien wrote:
Try removing the backticks around the table names. If you do use them, then all values (field names and table names) need it.I tried that and still chokes... 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%' group by m.AUCCIIM_ID order by m.preferred_last_name 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%'' at line 1 Sigh... Don