Forgot Password / Register
Site Statistics
Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 594
0 Users 16 Guests Online
Forum Index » PHP + MySQL » Online User Script
Posted on Sunday 6th May 2007 at 08:03 AM
gbt91
templates/default/images/noavatar.png's Avatar
Junior Member
I was thinking how to do this i've tried various ways but nothing...
can someone help me?
it suppose to display the current online users and maybe also thier name
Posted on Monday 7th May 2007 at 12:29 AM
Diablosblizz
templates/default/images/noavatar.png's Avatar
Senior Member
You could just make the login also put a mysql query into the database like the number one, and then get the mysql to count how many number 1's there are and classify them as online.

As the users, I think you could do the same thing, but instead of saying online just get their username.

I would try, but I know I would fail. I try anyways :).
Posted on Sunday 13th May 2007 at 09:46 PM
SkillMaster
templates/default/images/noavatar.png's Avatar
Senior Member
As diabloblizz said when they login update the user and edit
a new column called online make it 1 when they login then 0 when they logout.

then you would grab them by going.
Code

$sql= mysql_query("SELECT * FROM members WHERE online = '1'");
while($fetch = mysql_fetch_array($sql))
{
echo ("$fetch[username]");
}


there