DELETE FROM...

[Baseball]

If i use DELETE FROM WHERE Id running_time  > XXX

 

Does it run each time page is loaded? or only when it finds the WHERE ID = RUNNING_TIME > XX ?

[pneudralics]

Yes each time the page is loaded, the codes are reloaded.

[Baseball]

Yes each time the page is loaded, the codes are reloaded.

 

How do i set up to only load if user hasn't refreshed in 5minutes?

 

cause i dont want to run it each refresh.. lol

[Buddski]

You would need to store the last time (time()) the query was executed in the database..

Then before running the query do something like this..

$sql = "SELECT last_refresh_time FROM refresh_table WHERE id=ID LIMIT 1";
$sql_query = mysql_query($sql);
$l = mysql_fetch_assoc($sql_query);
if (time() - $l['last_refresh_time'] > 300) {
// run the delete query //
mysql_query("DELETE FROM WHERE Id running_time  > XXX");
// then update the time
mysql_query("UPDATE refresh_table SET last_refresh_time = '".time()."' WHERE id=ID");
}