Просмотр поста

как этот код правильно написать для отображения файлов

$query = mysql_query("SELECT * FROM `downfiles` WHERE `user_id` != 0 GROUP BY `user_id` ORDER BY COUNT(`user_id`)");
$total = mysql_num_rows($query);
$query = mysql_query("SELECT * FROM `downfiles` WHERE `user_id` != 0 GROUP BY `user_id` ORDER BY COUNT(`user_id`) DESC LIMIT " . $start . "," . $kmess);
if($total)
{
   while($arr = mysql_fetch_array($query))
   {
       echo ($i % 2) ? '<div class="list1">' : '<div class="list2">';
       $i++;
       $countt = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `user_id` = '".$arr['user_id']."'"), 0);
       $req = mysql_query("SELECT * from `users` where id = '".$arr['user_id']."';");
        $res = mysql_fetch_array($req);
       $arg = array ('stshide' => 1,
       'sub' => 'Всего файлов: '.$countt);
       echo functions::display_user($res, $arg) . '</div>';
   }

    echo'<div class="phdr">Всего: '.$total.'</div>';
    if($total > $kmess)
    {
        echo'<div class="menu">';
        echo '' . functions::display_pagination('top_user.php?', $start, $total, $kmess) . '';
        echo '<form action="top_user.php" method="get"><input type="text" name="page" size="2"/><input type="submit" value="К странице &gt;&gt;"/></form>';
        echo'</div>';
    }