Помогите подправить скрипт

SELECT * FROM characters LEFT JOIN char_templates ON char_templates.ClassId=characters.classid WHERE online ORDER BY exp DESC

echo "<thead><tr><th>№</th><th>аккаунт</th><th><center>Ник Чара</center></th><th>lvl</th><th>Class</th><th>Титул</th><th>клан</th><th>IP</th><th>email</th><th>дата реги</th><th>Баффы</th><th>скиллы</th></tr></thead></center>\n";

//присваиваем переменной o значение 1
$o=1;

//сливаем данные с запроса в переменную online
while ($online=mysql_fetch_array($onlinedata))

    {

//получение доп. инфы. по чару.
    mysql_select_db($dbname, $link);
    $AccInfa2 = mysql_query("SELECT * FROM accounts WHERE login ='$online[account_name]'");
    $AccInfa = mysql_fetch_array($AccInfa2);
    $AccInfa3 = mysql_query("SELECT * FROM zl_accounts_info WHERE account ='$online[account_name]' ORDER BY reg_date DESC");
    $AccInfa4 = mysql_fetch_array($AccInfa3);
    mysql_select_db($L2JBS_config["mysql_db"], $link);
    if ($AccInfa4[mail]=='') { $AccInfa4[mail]="-"; }
    if ($AccInfa4[reg_date]=='') { $AccInfa4[reg_date]="-"; }

    $clan=mysql_fetch_array(mysql_query("select * from clan_data where clan_id=$online[clanid]"));
    if ($clan[clan_name]=='') { $clan[clan_name]="-"; }
           if ($online[title]=='') { $online[title]="<font color=red>Empty</font>"; }
    $class=mysql_fetch_array(mysql_query("select ClassName from char_templates where ClassId=$online[classid]"));

//вывод данных в таблицу
echo "<tr><td><center><b>$o</b></center></td><td><center><a onClick=\"window.open('char_inventory3.php?login1=$online[account_name]','popup','width=850,height=400,status=no,resizable=no,scrollbars=yes,left=200,top=200')\" href=\"#\">$online[account_name]</a></center></td><td><center><b><A href=char_inventory1.php?name=$online[char_name]>$online[char_name]</a></b></center></td><td><center>$online[level]</center></td><td><center>$class[ClassName]</center></td><td><center>$online[title]</center></td><td><center><a onClick=\"window.open('clanview.php?clannameN=$online[clanid]','popup','width=850,height=400,status=no,resizable=no,scrollbars=yes,left=200,top=200')\" href=\"#\">$clan[clan_name]</a></center></td><td><center><A href=lastip.php?lastipR=$AccInfa[lastIP]>$AccInfa[lastIP]</center></td><td><center><A href=http://yandex.ru/yandsearch?text=$AccInfa4[mail] target=_blank>$AccInfa4[mail]</a></center></td><td><center>$AccInfa4[reg_date]</center></td><td><center><a onClick=\"window.open('buffs.php?obj_ids=$online[obj_id]&charNAMEs=$online[char_name]','popup','width=850,height=700,status=no,resizable=no,scrollbars=yes,left=300,top=80')\" href=\"#\">баффы</center></td><td><center><a onClick=\"window.open('skills.php?obj_ids=$online[obj_id]&charNAMEs=$online[char_name]','popup','width=850,height=700,status=no,resizable=no,scrollbars=yes,left=300,top=80')\" href=\"#\">скиллы</center></td></tr>\n";

//добаляем переменной o +1.
    $o++;
    }