Select Online User

[naruponk]

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

$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

[john tindell]

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

$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

$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']}'
                                )"; 

[naruponk]

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

[john tindell]

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

That selects the users within the lat five minutes.

[naruponk]

Thanks man