Help (mktime)

[Barrucadu]

$timeout = 15;
$t_stamp = mktime(date('H'),date('i')-$timeout,date('s'));
die($t_stamp);

That should return the time (in mysql format) 15 minutes ago, but it dosnt. It dosnt return anything.

Whats wrong?

 

[Noobie]

echo $t_stamp;
die();

why?
die() does not print integers
die("$t_stamp");
works too

 

[Barrucadu]

It dosnt print integers?

*feels stupid now*

lol

--edit--

Now I have a different problem:

	function Update_Stats($timeout,$stats){
		$t_stamp = mktime(date('H'),date('i')-$timeout,date('s'),0,0,0);
		
		$this->Database_Query('delete from ' .$stats . ' where visited < '.$t_stamp);
	}

the field visited is a mysql time.
It should delete all entries where visited is more than 15 mins ago, but it deletes everything.

 

[Noobie]

i'm not sure why, but you can use int for timestamps

 

[TwistMyArm]

PHP timestamps and MySQL datetimes are not the same thing... it all depends on your column types.

There is a MySQL function called something like UNIXTIMESTAMP that will return a MySQL date as a timestamp and I know there's one for converting from UNIX to MySQL, but I don't know it off the top of my head. However, do some digging for UNIXTIMESTAMP and you're bound to find the 'reverse' function name.