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
