PHP & MySQL (UPDATE statement)

[vlad230]

Hello guys!

I'm currently working on a script that should empty a field in a database every 24h.

list($hour, $minute, $second) = explode(":", date("H:i:s", time()));
$empty = "";
if( (intval($hour) == 0) && (intval($minute) == 0) && (intval($second) == 0) ){
	mysql_query("UPDATE `contest` SET 24h_ips='".$empty."' ");
}

The problem is that I thought it will execute even if no one accesses the page (@ 00:00:00), but it seems that I was wrong.... In order to execute someone has to access the page in that precise moment....

Is there some way to make it execute even if no one accesses the page at that time?

Thanks a lot,
Vlad

 

[Kate]

What you need is cron job to schedule that task.

 

[vlad230]

Thanks, I've managed to set one up