Page 1 of 1

mysql and php time diffrence deletes

Posted: Mon Jul 20, 2009 12:10 pm
by Sideclef
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

Code: Select all

$killtime=(time() - 299); 
$up="DELETE FROM table WHERE time=time < '$killtime'";  

Re: mysql and php time diffrence deletes

Posted: Mon Jul 20, 2009 12:55 pm
by Sideclef
Never mind I swear I am not that retarded big big overlook on my part...