Who's Logged In?

aspekt9

I'm trying to figure out who's logged into my user system. I've created a table with the username password and all that jazz. I've got all the authentication working but I want to list who's currently logged in on the homepage. So is what I did is create another row in the table called loggedin and it's defaulted to 'no'. When the user logs in its updated to 'yes'. It works and displays on the page but how can I get it to list all the logged in users instead of just the first one it finds? Here's my code:

		$result = mysql_query("SELECT username FROM users WHERE loggedin='yes'");
		$row = mysql_fetch_row($result);
		echo '<b>'. $row[0] . '</b>';

I would imagine that I would need to implement a sort of counting method to count how many people are logged in and then some how output that to show who exactly is logged in.

leatherback

Hi,

-- You really shold post in the beginners forum if you do not know how to retrieve multiple rows from a table. ANyway..

$result = mysql_query("SELECT username FROM users WHERE loggedin='yes'");
        while($row = mysql_fetch_row($result))
       {
        echo '<b>'. $row[0] . '</b>';
       }

Note that just adding a colum to your table won't fly: You need to check whether people are actually stioll logged in. Most people do not log out. They just leave. So you might want to make a table logged in, with a timestamp colum in it, which updates every time a user loads a page. You can then check this table for the number of users active in the last N minutes.