mysql and php time diffrence deletes
Posted: Mon Jul 20, 2009 12:10 pm
I have have looked all around for an answer for this and and haven,t found much on it...I am not that great in mysql...only the basics really...I want to delete all fields where the time difference is 5 minutes from the last update...I am inserting the update with php time()...I honestly have no idea how to go about it....any help would be appreciated...
this is how I have it written but it done work
this is how I have it written but it done work
Code: Select all
$killtime=(time() - 299);
$up="DELETE FROM table WHERE time=time < '$killtime'";