Best way to do something...

[Anon]

Hey guys,

Okay here's what I want to do. I want a script that has the ability to list who's browsing the site.. Members or Guest's.

I can do all of the member etc. stuff... But I'm just a bit puzzled on how to do the 'Currently Browsing Now....' bit. I'm using MySQL and PHP R102.

Thanks for any help.

[Anon]

I guess you list your members from the data they enter at login.

Guests probably don't login, so the only way to track them is to use the
http vars you get from the browser, like HTTP_USERAGENT,
or by reading the webserver log.

[Anon]

I agree with Vincent...

if you got a session table in your database do a select on everyone and join it with the table that got the users names... you could also make a guest table just to keep count of how many guest are currently browsing...

guest table

CREATE TABLE guests(
last_active timestamp NOT NULL,
ip_number varchar(15) NOT NULL,
);

to tell how many guests are online do something like

SELECT count(ip_number) AS guests_online FROM guests;

but you gotta remmeber to do a DELETE FROM guests WHERE last_active < Now()-1800;
or something like that to make the guest sessions time out...

Andreas Bernhardsen