joshblevins
Member
I am trying to run a php script to update a field based on if a date is x amount of days away or past the current date.
PHP SETUP SCRIPT
$id= {additional_certifications___id}
$status = {additional_certifications___status};
$expdate = {additional_certifications___expiration_date};
PHP SCRIPT
if $expdate < strtotime( '120 days' ) ) {
$sql = "UPDATE additional_certifications SET status='2' WHERE id=$id";
$result = query($sql);
}
elseif $expdate > NOW{
$sql = "UPDATE additional_certifications SET status='3' WHERE id=$id";
$result = query($sql);
}
PHP SETUP SCRIPT
$id= {additional_certifications___id}
$status = {additional_certifications___status};
$expdate = {additional_certifications___expiration_date};
PHP SCRIPT
if $expdate < strtotime( '120 days' ) ) {
$sql = "UPDATE additional_certifications SET status='2' WHERE id=$id";
$result = query($sql);
}
elseif $expdate > NOW{
$sql = "UPDATE additional_certifications SET status='3' WHERE id=$id";
$result = query($sql);
}