Delete Row After 30 Mins

[aeboi80]

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:

 

id int(11)
username varchar(15)
password varchar(41)
userlevel int(11)
timestamp time

 

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:

 

<?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);

?>

 

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.

[Mchl]

Try

DELETE FROM users WHERE userlevel='3' AND TIMEDIFF(NOW(),`timestamp`) > 1800