Ryan A wrote:
Hi,
I have a profiles page where next to the username I have a icon that says
"Online" or "Offline" if the
persons whose profile you are browsing signed in or clicked anything in the
last 3 minutes (I am also
using a meta refresh to call a script every 2 1/2 mins)
this is how i am doing it:
$check_if_member_online="select NOW() < DATE_ADD( last_online, INTERVAL 3
MINUTE ) as j_is_online FROM `".$prefix."members_online` WHERE cno
='".$jno."' and member_name='".$username."' LIMIT 1";
This is the table it calls
_members_online (
cno bigint(20) NOT NULL default '0',
member_name varchar(30) default NULL,
last_online datetime default NULL,
KEY member_name (member_name),
KEY cno (cno),
)
and its working fine.
I want to add this same functionality to a forum on the same site (the forum
was custom programmed
from scratch and not any of the popular ones), but since in a single thread
there can be a lot of different
people/usernames that answer I would prefer _not_ to do a select lookup for
each username...
any ideas on how else it can be done?
Thanks,
Ryan
I'd say start with a query that pulls the online users into an array,
then do an array_key_exists() or in_array() against that.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
