Compare two dates with a number

[claust]

Hi

I have a small php website where I need to compare todays date with a registration date and if the date is exactly 40 days ago I will send a mail out

I have the following query, but it is not working - anybody got an idea why

$query = "SELECT name,email,date FROM tabel1 WHERE TO_DAYS(tabel1.date) - TO_DAYS(CURRENT_DATE) == 40"

Hope for a response soon

Regards
Claus

 

[r937]

WHERE tabel1.date = CURRENT_DATE - INTERVAL 40 DAY

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon