Another MySQL Query

[JustJay]

OK so in English I want to do this...😕

Update the Valid field to NO if today is 21 days later than the Date in the Input field

So it is the 21 days later bit that has me confused on how to do

here is my attempt...not that I expected it to work....but its kind of the idea of what I want...

UPDATE DFAIT SET Valid = 'NO' WHERE UNIX_TIMESTAMP() >= UNIX_TIMESTAMP(InputDate++(86400*21));

Cheers thanks!

[tekky]

$past = strtotime('-21 days', mktime());
$past = date('Y-m-d', $past);
$sql = "UPDATE DFAIT SET Valid = 'NO' WHERE $past >= InputDate"
$result = mysql_query($sql);

that should work....

basically mysql can compare dates in dateformat too...
so just take today, get the timestamp for 21 days ago...

compare if its >= InputDate in YYYY-mm-dd format... and you're all set

[JustJay]

Of course...how obvious.... doh!

Thanks for your help!!!

[tekky]

hehe no prob 😉