Total views on non-vb page (Query included)

[Logician]

mysql_result should be used once for a variable. Then the assigned var becomes an ordinary variable and you can use it WITHOUT mysql_result.. So you used

PHP Code:

$numberguest=mysql_result($loggedins,0); 


in your code and assign the result to "$numberguest" var which is now an ORDINARY variable. From now on whenever when you want to use $numberguest use it as it is (ie. without mysql_result!)

So replace line echo mysql_result($numberguest,0); to

echo $numberguest;

BTW you else syntax is wrong either: it should be:

PHP Code:

if (mysql_error()) {echo "mySQL error:"; echo mysql_error(); exit;}                                                //show error if any
else
{
echo $totalonline ;
echo $numbervisible ;
echo $numberguest;
} 


Seems you are tired, give it a rest..

[wooolF[RM]]

I think MAYBE it's because of $cookietimeout variable... it's not defined any places... what do you think?

[wooolF[RM]]

]well... maybe I'm tired maybe... but I have to get it working...

by now I have no errors anymore! YAY!

but visual results are:

Active Users 0
Active Members
Active Guests 0

And forum tells me this:
Active Users 46
Active Members 24
Active Guests 22


So... maybe you are tired too
Because Active Users and Active Guests working only at 50% (show wrong results) and Active Members doesn't show anything at all...

grrrrrrrrrrrr... why should everything be so difficult? :/

[Logician]

PHP Code:

mysql_connect("$servername", "$dbusername", "$dbpassword") or die("Couldnt find MYSQL!");
mysql_select_db("$dbname")  or die ("Couldnt find DB!");


// STARTING QUERIES HERE
$aktiveuser = mysql_query("SELECT COUNT(userid) FROM user");
$registers = mysql_query("SELECT userid, username FROM user ORDER BY userid DESC LIMIT 1");
$datecut= mktime (date("H"), date("i")-15, date("s"), date("m"), date("d"), date("Y"));
$loggedins=mysql_query("SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity > $datecut");
$numberguest=mysql_result($loggedins,0);
$loggedins=mysql_query("SELECT DISTINCT session.userid,username,invisible,usergroupid
                              FROM session
                              LEFT JOIN user ON (user.userid=session.userid)
                              WHERE session.userid>0 AND session.lastactivity>$datecut
                              ORDER BY invisible ASC, username ASC");
while ($loggedin=mysql_fetch_row($loggedins)) {
    $numberregistered++;
    if ($loggedin[2]==0) {$numbervisible++;}
}
$totalonline=$numberregistered+$numberguest;
$numberinvisible=$numberregistered-$numbervisible;
// END OF QUERIES HERE

echo 'totalonline='.(int)$totalonline; echo("<br><br>");
echo 'numbervisible='.(int)$numbervisible; echo("<br><br>");
echo 'guests='.(int)$numberguest; echo("<br><br>"); 


[wooolF[RM]]

]you're the man, Logician! worked perfectly...

as you see, it's not easy to get it working... u have to use different ways... well... that's PHP...

anyway, THANX A LOT!!! I really appreciate your help