[PHP] Online User Total

[Serenduk]

Im trying to set a php page to display online user total i have the following code:

PHP Code:

<?php
@$connect = odbc_connect("Driver={SQL Server};Server={".$host."}; Database={".$db2."}", "".$user."", "".$pass."") or die("<center><b style=\"border:1px dashed #FF0000;\">".str_replace("[Microsoft][ODBC SQL Server Driver][SQL Server]", "", odbc_errormsg())."</b></center>");
@odbc_result_all(odbc_exec($connect, "SELECT TOP (".$show2.") nUserCount as Online FROM _ShardCurrentUser WHERE nShardID = 64 ORDER BY nID DESC"));
echo "
                    <b>Server: <span style='color:red'><i>Sro </i></span> - <span style='color:#000'>$row[nUserCount]</span><span style='color:green'> of maximum</span> <span style='color:#000'>1000</span> <span style='color:green'>are currently online!</span></b>    
                    ";
        
?>

This code shows a box with total number of user's but im trying to get it to spit out the total where $row[nUserCount] is can anyone point me in the right direction or any script already out there with odbc connection >?

[Serenduk]

any help please ?

[silkroadnet]

PHP Code:

<?php 
$host = "host"; //Host
$db2 = "SRO_VT_ACCOUNT"; //DB
$user = "username"; //username
$pass = "pw";  //pw
$show2 = 1; 
@$connect = odbc_connect("Driver={SQL Server};Server={".$host."}; Database={".$db2."}", "".$user."", "".$pass."") or die("<center><b style=\"border:1px dashed #FF0000;\">".str_replace("[Microsoft][ODBC SQL Server Driver][SQL Server]", "", odbc_errormsg())."</b></center>"); 
@odbc_result_all(odbc_exec($connect, "SELECT TOP (".$show2.") nUserCount as Online FROM _ShardCurrentUser WHERE nShardID = 64 ORDER BY nID DESC")); 
echo " 
                    <b>Server: <span style='color:red'><i>Sro </i></span> - <span style='color:#000'>$row[nUserCount]</span><span style='color:green'> of maximum</span> <span style='color:#000'>1000</span> <span style='color:green'>are currently online!</span></b>     
                    "; 
         
?>

[Serenduk]

thats just adding the db connect info im already connecting but as i put it displays stats in a block not in the area required if u test and look