update record at a particular time

[roshanjameer]

hi,

i want to update a record everyday at a particular time dynamically.
how can i do this

thanks
mrjameer

[devinemke]

cron

[roshanjameer]

hi,

when a user will upload files on my site,the file info will be stored in table.and it will also shows a link to the user to download or visit that file.when he visits the link,the counter in table will be incremented.on every day at a particular time i want to update the counter to zero.that's all

<?php
$current_date=date('Y-m-d');
$current_time=date('H:i:s');

if($current_date  && $current_time >= '23:59:00')
{
	mysql_connect($dbServer, $dbUser,$dbPass);
   mysql_select_db($dbName);
	$sqlquery="UPDATE images SET count='0'";
	$resultquery=mysql_query($sqlquery) or die (mysql_error());
}
?>

thanks
mrjameer

[devinemke]

run a cron every night at midnight that updates the count to 0