Im trying to structure a query for my website which selects the users whose membership is nearing expiry and I cant get it to work. Im not sure where im going wrong
Code: Select all
SELECT * FROM Customers WHERE member_level='full' AND expiry_date < ADDDATE(NOW(), INTERVAL 32 DAY)Why does the ADDDATE function work for an INSERT (I have it working for this elsewhere) but not a SELECT ?
Any help is always appreciated
Thanks in advance as always
EC