[Help] ODBC or mssql

[cristitm]

Most of the codes that i found here in ragezone, or in other websites dont work

example what code work :

<?$online = $core_db2->Execute( "Select memb___id from MEMB_STAT where ConnectStat='1'" );echo "".number_format( $online->RecordCount( ) )."";?>

example what code dont work :

<?
$statistics_accounts=mssql_query("SELECT count(*) memb___id FROM MuOnline.dbo.MEMB_INFO");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['accounts_reults']=$row['memb___id'];
?>
<?=$core['accounts_reults'];?>
<?

}
?>

it's because when i installed mucore i selected ODBC instead of MYSQL?

 

[mesosa]

That's because your query and what you do next does not match.

Your query is just returning the amount of accounts i guess ( i don't know what MEMB_INFO table is ).

And then you are searching for memb__id column.

You should change this

$row['memb___id']

for this

$row[0]

 

[cristitm]

i'm trying to add on my index.php all the accounts that are made on my server

ex : Total accounts : 75
Total Characters : 125