I dont have the first code i need to chage.
all i have is:
$onlineNow = $DB_site->query( "SELECT s.userid, u.username, s.location FROM session s LEFT JOIN user u ON u.userid = s.userid WHERE s.userid <> 0 AND u.invisible = 0 ORDER BY u.username ASC" );

So i replaced this instead of the one that the instructions shows, now i can see the guests but all the guests are recognized as guest (guest,guest,guest instead of- guest1,guest2,guest3), and for all the guests it shows 'unknown location'

[Edited by Scaramanga_gold on 12-21-2000 at 08:15 AM]