[SOLVED] Compare time with time stored in database

[web_master]

Hi,

 

I store the Datetime into database in format: 0000-00-00 00:00:00

 

in every pageload there is a new Datetime is stored,

 

<?php 

// Here is the problem - if user aint do anything in past 2 or 3 min than will treat as Logged Out. Time format is 0000-00-00 00:00:00 or???
$query_return = mysql_query("SELECT * FROM `user` WHERE `user_logintime` > '2 min' ");



if(!$query_return) {
	print mysql_error();
	exit;
}

$request = mysql_fetch_array($query_return);

if($request['user_login']) {
print "USER IS ONLINE";
} else {
print "USER IS OFFLINE";
}
?>

 

I hope You understand...

[DarkWater]

#SQL
SELECT * FROM user WHERE user_logintime > DATE_SUB(NOW(), INTERVAL 2 MINUTE);

[web_master]

Its work great!!!

 

Now, I can see the other problem: I have a query

 

<?php 
$query = mysql_query("SELECT * FROM `users` WHERE `users_onoff` = '1' AND `users_delete` = '0' ORDER BY `users_familyname` ASC");



while($request = mysql_fetch_array($query_return_onlinen)) {

//How can I do a same thing If I have a query
if($request['user_logintime'] > 2min) {
print "online";
} else {
  print "offline";
}
}

?>

[web_master]

[Barand]

if(strtotime($request['user_logintime']) > strtotime('-2 minutes')) 

 

or

 

if(strtotime($request['user_logintime']) > time() - 120 ) 

[web_master]

if(strtotime($request['user_logintime']) > strtotime('-2 minutes')) 

 

or

 

if(strtotime($request['user_logintime']) > time() - 120 ) 

 

Barand, THNXS