php batch trigger

[andibakker]

I have a mysql database with fields raceflag, racedatetime and cutoffhours.  I need a job to run and update the raceflag to "closed"  when the systemtime is = racedatetime - cutoffhours.  something like this

UPDATE race 
SET raceflag = 'closed'  
WHERE now() >= DATE_SUB(racedatetime, INTERVAL cutoffhour hour)");  

 

What is the best way to do this ?

Schedule a job to run every minute and check the current time ?  Is there another way ?

Thanks

Andi

[trq]

Scheduling a job is probably the only way to get it done reliably.