I have a small logic problem and I want to read the entries from the database that correspond to the date – 30 days, currently I have it like this:
WHERE `expires` = CURDATE() - INTERVAL 30 DAY AND `paymentIntervall` = '1' AND `status` = '1'
But that doesn’t work somehow, so it should only be output on the day where expires – 30 days is.
PS. Columne is datetime.
Thanks in advance 🙂