[Help] Solving the code

[cristitm]

hey guys,

so this is the ranking code that works

$Chars=$core_db->Execute("select TOP 10 Name,cLevel,Resets from Character Where ctlcode !='32' and ctlcode !='8' order by Resets desc, cLevel desc");while(!$Chars->EOF){?>                            <td><div align="center" class="Estilo36">                               <span style="color:#DDBE49;"><?=++$count1;?></span>                            </div></td>                            <td><div align="center" class="Estilo36">                                <?=$Chars->fields[0];?>                            </div></td>                            <td><div align="center" class="Estilo36">                                <?=$Chars->fields[1];?>                            </div></td>                            <td><div align="center" class="Estilo36">                                <?=$Chars->fields[2];?>                            </div></td>                          </tr>                          <?$Chars->MoveNext();

and with my non knowladge of php i make this

?>online : <?$online = $core_db->Execute("select ConnectStat FROM MEMB_STAT WHERE ConnectStat = 1", array($online->fields[0]));?><?$count=1;?>

but its not working... what i do wrong?



i found by searching on ragezone thanks everyone

for who need :

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

and also http://forum.ragezone.com/f197/mu-core-basic-online-counter-848002/