[SOLVED] MySQL Date > DATE_ADD(CURDATE(), INTERVAL -3 DAY)

[tekrscom]

PHP version 5.2.5

MySQL version 5.0.81-community-log

 

Hi, I'm wanting to create a script to run clean up on my members, to delete members that have not validated their email and it has been greater than 3 days since they created their account...

 

Here is what I have, but it is giving results that are within the 3 days...

$query = "SELECT UserID FROM Users WHERE EmailValidated = 'No' AND (StartDate > DATE_ADD(CURDATE(), INTERVAL -3 DAY))";

 

Can someone please help?

 

 

[tekrscom]

Whoops... I found the obvious problem... should be < not >

 

$query = "SELECT UserID FROM Users WHERE EmailValidated = 'No' AND (StartDate < DATE_ADD(CURDATE(), INTERVAL -3 DAY))";