Hi Guys. I would like some help on a script that execute a mysql query, checking if the current time is not equal at the time saved on the database. I mean if the time saved on the DB =
2004-10-18 17:09:31 and the current time = 1 hour after or more execute the mysql query.
I had done this:
PHP Code:
$timestamp = time();
$datum = date("Y-m-d H:i:s",$timestamp);
$todaysDate =date("H:i:s");
$count = 3600; // 1 hour
$temp =$todaysDate + $count;
if ($temp){
mysql_query("DELETE FROM psc_sessions WHERE date<>'$datum'",$conexion);
}
Thanks in advance
