need help with online status indicator

[dud3r]

Basically, I want php to display "Online" if the user's last login time ($row['last_login']) was less than 10 minutes ago ($time_ofusers, which is set in another file (config.inc.php)) but if the time was more than 10 minutes ago, the user is shown as "Offline".
I know that my code is waay wrong.

if (date('F j, Y, g:i a',strtotime($str2) >= date_sub(now(),interval $time_ofusers minute)) {
	echo "Status: Online
}
else {
	echo "Status: Offline";
}

I tried googling it and looking on php.net but I don't really know what I'm looking for..
Thanks in advance for any help.

[laserlight]

Where and in what format are you storing the time information?

[dud3r]

it's stored in DATETIME format (2004-12-17 22:54:17 <-- time right now)
..in a table called "users", in the "last_login" field.

[Weedpacket]

Did you try MySQL's documentation on date and time functions (assuming the DATETIME field is in a database in MySQL)?

[dud3r]

I posted that wrong. Sorry. The code I was trying was

if ($row['last_login'] >= date_sub(now(),interval $time_ofusers minute)) { 
    echo "Status: Online";
} 
else { 
    echo "Status: Offline"; 
}

$row['last_login'] is in DATETIME format and "$time_ofusers" is 15.
Basically, I want it to do

if (last login time was less than 15 minutes ago) {
echo "Status: Online";
}
else {
echo "Status: Offline";
}

but I can't put those words into code.
kicks self for being such a newbie

[weekender]

the easist way to get this working is to modify your sql select statement to return a unix_timestamp

SELECT *, UNIX_TIMESTAMP(last_login) AS unix_last_login FROM tablename WHERE 1

then you can compare the timestamps directly

if($row['unix_last_login'] >= now()-900){
echo "User logged in less than 15 mins (900 seconds) ago";
} else {
echo "User has not logged in in the last 15 mins";
}

hope that helps

adam

[dud3r]

Yes. That helped A LOT. Thank you.
I had to use time() instead of now() to get the code to work.
I used this:

if($row['unix_last_login'] >= time ()-900){
echo "User logged in less than 15 mins (900 seconds) ago";
} else {
echo "User has not logged in in the last 15 mins";
}

instead of

if($row['unix_last_login'] >= now ()-900){
echo "User logged in less than 15 mins (900 seconds) ago";
} else {
echo "User has not logged in in the last 15 mins";
}

[weekender]

yeah always get those two mixed up. anyway glad i could be of help

adam