Jump to content

update record at a particular time


mrjameer

Recommended Posts

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

 

 

my code is

<?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

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.