[Help] Solving the code

hey guys,

so this is the ranking code that works

PHP Code:

---

$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

PHP Code:

---

?>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?

- - - Updated - - -

i found by searching on ragezone :) thanks everyone

for who need :

PHP Code:

---

?>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-co...ounter-848002/