Breadcrumbs

[Dummy1912]

hello,

Code: Select all

$q = mysql_query("SELECT COUNT(*) FROM `users` WHERE ((`username`='$friend_id' AND `onlinestatus`='online') OR (`username`='$friend_id' AND `onlinestatus`='away'))");
            $n = mysql_num_rows($q); //COUNTS USERS ONLINE

            echo $n;

it count all users that are in the list
instead to calculated how many users are online , away , busy
and show it?

anyone a idea how to do it?

thanks

[Filip]

Code: Select all

//Connection stuff
$total = 0;
$con = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
	if (!$con)
	  {
	  die('Error while trying to connect to db: ' . mysql_error());
	  }

	mysql_select_db(DB_NAME, $con);
	
	
	$result = mysql_query("SELECT `onlinestatus` FROM `users` WHERE `username`='$friend_id'") or die(mysql_error());
	$row = mysql_fetch_assoc($result);
	foreach($row as $content) {
        if ($content=='online') {
            $total++;
        }
        else if ($content=='away') {
            $total++;
        }

}
echo $total;

[Dummy1912]

hello filip,
thanks for reply.

but does not count?

lets say you have 10 friends
2 are offline

3 away
3 online
2 busy

so it will show : 8

you understand what i mean

[Filip]

Oh sorry,

I misunderstood the question

I edited the code on first reply

[Dummy1912]

hello #Filip
thanks again

but :( not working

[Filip]

What is the error that you are getting?

[Dummy1912]

no error just nothing to display :(

[Filip]

There was a typo, try again.

Did you fill in the sql connection fields?

[Dummy1912]

seems its not calculating it only show 1

[Filip]

Try running

Code: Select all

SELECT `onlinestatus` FROM `users` WHERE `username`='put something here'

in phpMyAdmin and see the results