Файлы пользователей

Koenig (01.10.2012/17:38)
LYCUK, $datauser поменял на $user?
$total = mysql_result(mysql_query("select count(*) from `forum` join `cms_forum_files` on cms_forum_files.del=0 and forum.id=cms_forum_files.post and forum.from='"

if ($total>0) {
while ($row = mysql_fetch_assoc($sql)) {
echo  ($i % 2 ? '<div class="list2">' : '<div class="list1">') . '<div><a href="?act=file&id=' . $row['id'] . '">' . $row['filename'] . '</a></div>' .    
'<div>Загрузил ' . $_GET['list'] . ' Скачали раз (' . $row['dlcount'] . ')</div>' . 
'<div><a href="?id=' . $row['topic'] . '">Тема форума</a> | <a href="?act=post&id=' . $row['post'] . '">Пост форума</a></div></div>';
++$i;
}

$total = mysql_result(mysql_query("select count(*) from `forum` join `cms_forum_files` on cms_forum_files.del=0 and forum.id=cms_forum_files.post and forum.from='" . $user['name'] . "'"), 0);
echo $total;

echo '<div class="topmenu">' . functions::display_pagination('?act=ufiles&amp;list=' . $_GET['list'] . '&amp;', $start, $total, $kmess) . '</div>';

} else {  
echo functions::display_error('' . $_GET['list'] . ' не имеет файлов на форуме');
}
} else {
$sql = mysql_query("select forum.user_id, forum.from from `forum` join `cms_forum_files` on forum.id=cms_forum_files.post");    
$arr = array();
while ($row = mysql_fetch_assoc($sql)) {
$arr[$row['user_id']] = $row['from'];
}

Koenig (02.10.2012/12:20)
LYCUK, попробуй так
$total = mysql_result(mysql_query("select count(*) from `forum` join `cms_forum_files` on cms_forum_files.del=0 and forum.id=cms_forum_files.post and forum.from='" . $_GET['list'

Koenig (02.10.2012/13:03)
LYCUK, перед запросом где есть лимит поставь
$kmess = 10;