Active User Function

[fnbcprog]

Hey thanks for taking a look at this problem.
I am trying to create a function that enables me to call it from any page and it will tell me what users are logged on at the present time.

First I want to connect to my database and retrieve the number of users online and there username.
After I have the number of user (mysql_num_rows) and all the usernames (from the select statement) I need to know how to return more than one value.

function checkstatus() {

$link = @mysql_connect("host","user","pass");
@mysql_select_db("database",$link);
$sql = "SELECT user FROM users
	WHERE status='Active'";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);

for($x=1;$x<=$num_rows,$x++) {
                 $row = mysql_fetch_array($result);
                   "some option here"
           }

           return $activeusers;
}

[planetsim]

return only returns 1thing. SO maybe use a while loop and use the var thats gonna get the information from the database to be returned.

[dustbuster]

I would suggest doing the following in your for loop:

for($x=1;$x<=$num_rows,$x++) {
                     $row = mysql_fetch_array($result);
                     $activeusers[$x-1]=$row;
                     //use $x-1 as we started with $x=1 
               }

           return $activeusers;
}

You can return an array from a function then you use something like:

$thestatus=checkstatus();
for ($i=0;$i<count($thestatus);$i++)
	foreach ($thestatus[$i] as $value) {
                echo "Value: $value<br>\n";
}

My coding might be a bit off but I hope it helps