Delete Row After 30 Mins
Posted: Thu May 07, 2009 5:04 pm
Allow me to preface this post with the fact that I am not very familiar with sql statements and such, but I have been tasked with completing this job. I have a table called users which contains the following fields:
I need to have a row deleted after 30 minutes of it being created. I plan to use a cronjob to accomplish this...but I alas I don't know the sql to do it. Here is the code I have so far:
As you can see I am not sure what to do because this is obviously not correct. First I realize I am dealing with a MySQL timestamp and trying to use a Unix-Timestamp and not sure how to get around this. I have searched Google and found several variations, but nothing I can piece together to make it work.
Code: Select all
id int(11)
username varchar(15)
password varchar(41)
userlevel int(11)
timestamp timeCode: Select all
<?php
$con = mysql_connect("localhost","test","abcd1234");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$currentTime = time();
$deleteTime = time() - (1800);
mysql_query("DELETE FROM users WHERE userlevel='3' && $deleteTime <= $ currentTime");
mysql_close($con);
?>