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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
