How to i take an hour off this code

[SamDOD]

<?php
function checkTime(){
$db=new mysql_dialog();
$db->connect($this->dbhost, $this->dbuser, $this->dbpass, $this->dbase);
//$SQL="SELECT CURTIME(".$this->tblLastLog.") as lastLog FROM ".$this->tbl;
$SQL="SELECT UNIX_TIMESTAMP(".$this->tblLastLog.") as lastLog FROM ".$this->tbl;
$SQL.=" WHERE ".$this->tblID."=".$_SESSION['userID']." AND ".$this->tblSessionID."='".$_SESSION['sessionID']."'";
$db->speak($SQL);
$data=$db->listen();
$nowtime=time();
$inactiveSec=$nowtime-$data['lastLog'];
if ($inactiveSec/60>$this->inactiveMin) {
$this->errorMsg=$this->errorDelay;
$this->makeErrorHtml();
}
else {
$SQ="UPDATE ".$this->tbl." SET ";
$SQ.=$this->tblLastLog."= now() ";
$SQ.="WHERE ".$this->tblID."='".$_SESSION['userID']."'";
$db->speak($SQ);
$this->checkAdmin();
}
}
?>

 

Where is says "$SQ.=$this->tblLastLog."= now() "; is where it gets the time, I am assuming. The server i am using is in a differant time zone so i need to ajust the time by minus an hour.

 

How do i do that?

 

Thank you for your help.

[CroNiX]

well, since UNIX_TIMESTAMP is in seconds, subtract 60 * 60 seconds to subtract an hour...

[SamDOD]

Where do i subtract it. I know that is probubly a dumb question but i am sort of new to all of this.

 

Thank you for your help.

[CroNiX]

$SQL="SELECT UNIX_TIMESTAMP(".$this->tblLastLog.")-3600 as lastLog FROM ".$this->tbl;

[fenway]

MySQL has an INTERVAL for use with DATETIME fields.

 

e.g. yourDateField - INTERVAL 1 HOUR