Select Online User

Hi there

How can i use SQL syntax to select a user who have lastvisit time within last 5 minutes?

I have try like this but failed

Code:

---

$result = mysql_query("Select * from tblmember WHERE " .( time() - 300 ) . " <= lastvisit;");

also

WHERE DATE_SUB(CURDATE(),INTERVAL -5 Minute) <= lastvisit

---

does anyone have an experience with something like this?
how can i do that

Thanks for advance

Hey, what is delete all the users who have been not be active within the last five minutes, or the current user

PHP Code:

---

$query = "DELETE FROM _ONLINE_USERS WHERE session_id = '". session_id() . "' OR DATE_SUB(now(), interval 5 minute) >= time"; 


---

Then i insert the current users information in to my _ONLINE_USERS table using

PHP Code:

---

$query = "INSERT INTO 
                                {$this->dbc->prefix}_ONLINE_USERS 
                                (username,ip_address,session_id,time,page,user_agent)
                            VALUES
                                (
                                    '$uname',
                                    '{$_SERVER['REMOTE_ADDR']}',
                                    '" . session_id(). "',
                                    NOW(),
                                    '{$_SERVER['PHP_SELF']}?{$_SERVER['QUERY_STRING']}',
                                    '{$_SERVER['HTTP_USER_AGENT']}'
                                )"; 


---

Is this a code that can use to select active user?

DATE_SUB(now(), interval 5 minute) >= time

I already have a column that use to keep user's lastvisit
can i just select by that column?

Thanks

Quote:

---

Originally Posted by naruponk

DATE_SUB(now(), interval 5 minute) >= time

---

That selects the users within the lat five minutes.

Thanks man :)