Просмотреть Код<center>
<div>
<div id="g_cont">
<font color="black">Топ пользователей по кол-ву аккаунтов.</font>
<p>
<center>
<table cellpadding="1px" cellspacing="1px" border="0">
<tr class='cp_prog_row_0'>
<font color="black">
<td class="header_account">ID:</td>
<td class="header_account">Логин:</td>
<td class="header_account">Акк-ов:</td>
</tr>
<?
include 'class.php';
$p = new ProjectZ;
$p->mysql();
$SQL = mysql_query("SELECT * FROM `users`");
while($row = mysql_fetch_array($SQL)){
if(!(2)){
$rowcolor = "cp_prog_row_1";
} else {
$rowcolor = "cp_prog_row_2";
}
$re1 = mysql_query("SELECT * FROM `accounts` WHERE `ref` = '".$row['id']."'");
$cont_ref = mysql_num_rows($re1);
$row['id'] = htmlspecialchars($row['id']);
$row['login'] = htmlspecialchars($row['login']);
if($cont_ref > 100){
$users[] = Array($row['id'], $row['login'], $cont_ref);
$test[] = $cont_ref;
}
}
arsort($test);
foreach($test as $id => $a){
foreach($users as $id => $b){
$i = 0;
while($i < 1){
$i++;
if($b[2] == $a){

echo '<tr class="'.$rowcolor.'">
<td class="tanki_account" width="20px">'.$users[$id][0].'</td>
<td class="tanki_account" width="140px">'.$users[$id][1].'</td>
<td class="tanki_account" width="140px">'.$users[$id][2].'</td>
</tr>';
}
}
}
}
?>
</font>
</table>
</center>
</p>
</div>
</div>
</center>