Re: Strange Query Error...

From:	Don Wieland	Date:	Sat, 27 Nov 2010 19:45:44 +0000
Subject:	Re: Strange Query Error...
References:	1 2 3 4 5 6	Groups:	php.general
Request:	Send a blank email to php-general+get-309730@lists.php.net to get a copy of this message

On Nov 27, 2010, at 11:35 AM, Daniel P. Brown wrote:

Strange... I have no idea what to do. I got to run it via PHP.
Don, on which table is the column member_year located? Is that on Members?

it is "Member_Years". I thought of that. I change 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(my.member_year + 1,'-07-01'), INTERVAL 1 DAY), INTERVAL 30 DAY) AND m.Preferred_First_Name LIKE 'd%' group by m.AUCCIIM_ID order by m.Preferred_Last_Name Still PHP choking and running perfectly in mySQL Workbench. If someone is feeling generous to assist real-time, I am available on SKYPE (skypename = dwdata) and can facilitate a GoToMeeting session. Pretty please - I just want to get this working and move on ;-) Don