Comparing mysql time in php

[Shadowing]

Hey guys, im having a slight issue with comparing mysql time stamp.

I'm using the timestamp in mysql to show how many people are online with in 5 minutes.

$sql = mysql_query("SELECT name,id FROM users WHERE DATE_SUB(NOW(),
INTERVAL 5 MINUTE) <= last_active ORDER BY id ASC"); 

But I want to grab last_active from the data base and compare it like below.  I dont know if strtotime just doesnt compare with mysql time stamp or what?

 

if($last_active > strtotime('-5 minutes')) {

	echo "<td>Online</td>";
}else{
	echo "<td>Offline</td>";

} 

 

 

 

[requinix]

I dont know if strtotime just doesnt compare with mysql time stamp or what?

Think. Why would it?

If your web and database servers are in different timezones then dates and times will differ between them. Pick one place to do dates. Personally I prefer using PHP for it, but that's just my choice.

 

Now, what you're saying is contradictory. Do you want only the people online within the last five minutes, or do you want all the people and to display which ones are online?

[Shadowing]

thanks for the responce requinix

 

Im recording the Time stamp with NOW. I figure that is 0 GMT. Thought strtotime was the same.

UPDATE users SET last_active = NOW()

 

but yah im displaying everyone and showing which ones are online and which ones are offline.

 

the query in my question is already is grabing the people online from with in the last 5 minutes. Sorry for the confusion on what im trying to do.

[Shadowing]

Yah i just assumed NOW was gmt so i need to go look up on how to make it record the time stamp in 0 GMT then. I didnt think once to check the time of the time stamp cause I thought it was a format issue lol. where it couldnt read it

[Shadowing]

Well im confused lol.

 

using NOW and using UTC_TIMESTAMP is giving me the same time, which is server time. and server time is -6. im wanting 0 so its the same as strtotime

 

anyone know what im doing wrong.

[Shadowing]

Ahh figured out my issue. The page i was making edits on wasnt even part of the page i was testing it on if i had it wraped in a function i wouldnt of had this issue