This is to update the timer in my DB and let the user know how much time they have left in the hospital in a game.

Is there a way to make this more accurate? For some reason once in a while the timer is getting stuck and not telling people the time is counting down.

please help!

   $thetime = time();

   $result2 = mysql_query("UPDATE `updates` SET `lastdone` = '".$thetime."' WHERE `name` = 'hospital'");

   $leftovertime = $timesinceupdate - (floor($timesinceupdate / 60) * 60);

   if ($leftovertime>0) {

      $newupdate =  time() - $leftovertime;

      $setleftovertime = mysql_query("UPDATE `updates` SET `lastdone` = '".$newupdate."' WHERE `name` = 'hospital'");

   }

php is done once the page has been sent to the browser, so the timer will stop.