Time Difference

delete yourtable
where timeInserted < DATE_SUB(CURDATE(),INTERVAL -1 MINUTE);

or better, to check against the time :
delete yourtable
where timeInserted < DATE_SUB(CURTIME(),INTERVAL -1 MINUTE);

try
delete yourtable where timeInserted < DATE_SUB(NOW(),INTERVAL -1 MINUTE);

angelIII, is this a SQL statment?

brian

can I add WHERE statments afterwards?

in php
<?
mysql_connect(HOST,USERNAME,PASSWORD);
@mysql_select_db(DATABASE) or die( "Unable to select database");

$sql = "Delete <table-name> where `timeInserted` < DATE_SUB(NOW(),INTERVAL -1 MINUTE)";
$result=mysql_query($sql);
if($result) {
    //deletion successful
} else {
   //unsuccessful
}
mysql_close();
?>

Does not work.


Insert like this ->
     $theTime = date("M j Y G:i:s");
     $varSQL = "INSERT INTO `tech` ( `techName` , `techIP`, `sessionID`, `port`, `lastUpdate` ) VALUES ('$name', '$techIP', '$ses', '$port', '$theTime')";
 

Check for old line this->

 $sql = "Delete `tech` where `lastUpdate` < DATE_SUB(NOW(),INTERVAL -3 MINUTE)";
 $result2 = mysql_query($sql, $dbh);

Try this
$sql = "Delete `tech` where DATE_FORMAT(`lastUpdate`,GET_FORMAT(DATETIME,'ISO')) < DATE_SUB(NOW(),INTERVAL -3 MINUTE)";

still doesnt work

It does nothing.

lastUpdate is varchar(100)


Brian

Is there a way I can do this via PHP to atleast beable to evaluate the output?

Brian

>angelIII, is this a SQL statment?
yes

>Does not work.
this is because of : lastUpdate is varchar(100)
how the "hell" did you come to make a datetime value into a varchar column.
get that column changed to datetime, and the delete will work correctly

>>this is because of : lastUpdate is varchar(100)
>>how the "hell" did you come to make a datetime value into a varchar column.
>>get that column changed to datetime, and the delete will work correctly


LOL...that post made my night...will fix asap.

AngelIII: That fixed that problem.

However, how do I update a record without using a string time that I generated. For example, one of the col's in the row is IP and one is lastUpdate.

I want to update IP with a string and lastUpdate I want to be the current Time. As you saw above I was using a string with the php date() function to do this.


-Brian

Brian, what delete query you used?

Once it was changed to a datetime field, angelIII's first post worked just fine.


Brian