Online Users Script

GundamSV7

Hey, I'm working on an users online script. Right now, at the top of the page, I have:

mysql_query("UPDATE users SET time=NOW() WHERE username = '$user'");

now, my script to retreive online users is:

$getonline = mysql_query("SELECT * FROM users WHERE time <= (NOW()-360)");
while($online = mysql_fetch_array($getonline)) {
echo "$online[username]<br>";
}

now, that's supposed to list the users that were online within the past 6 minutes, but for some reason it sometimes works but other times it lists all the users in the entire database. Anyone have an idea why?

drawmack

scour your code for an errant update query that resets everyone's last time to now. It could be one of two things, a messed up where clause or a clean up query going awry.

GundamSV7

I already checked, the only line that updates the time col in the database is at the top of the page:

mysql_query("UPDATE users SET time=NOW() WHERE username = '$user'");

That just sets the user's current time.

What do you mean by clean-up going awry?

drawmack

Originally posted by GundamSV7
What do you mean by clean-up going awry? [/B]

When I said scour your code I intended any code that issues any queries on this table. That include admin areas, cron jobs, etc.

By clean up code gone awry I mean something that cleans up your database on a schedule. My guess is that you're missing a where clause on an update and therefor all of the times in your database are being updated which is causing the misbehavior.

Erestar

Do you have some other way to view the tables in your database so you can determine for sure that the timestamps are improperly set in the tables, or if something is going wrong with your query when you're getting the data out ?