в чем ошибка?

Купить рекламу

Шины и диски для настоящих боссов дороги;

Обновить | Подписаться | Поднять тему

Чтобы выполнить действие авторизируйтесь или пройдите регистрацию на сайте.

Blood Rayne

0.04

[автор] (25 май 2015, 16:05) [1/0] [1] [отв] [спам] [под] +1 | -1

Выводит одну тему а не пять. Что не так тут ?
<?php
$theme = DB::$dbs-
>queryFetch("SELECT * FROM
".FORUMS_THEME." ORDER BY
`activ` DESC LIMIT 5";
if (!empty($theme)) {
echo DIV_BLOCK;
$posts = DB::$dbs-
>querySingle("SELECT COUNT
(`id`) FROM ".FORUMS_POST."
WHERE `theme_id` = ? ", array
($theme['id']));
$post = DB::$dbs-
>queryFetch("SELECT * FROM
".FORUMS_POST." WHERE
`theme_id` = ? ORDER BY `time`
DESC LIMIT 5", array($theme
['id']));
$page = ceil(($posts /
$config['write']['forum_post']));
echo '<li><a href="'.HOME.'/
forum/'.$theme['forum_id'].'/'.
$theme['forumc_id'].'/'.$theme
['id'].'/">'.$theme['name'].'</a>
['.$posts.'] <a href="'.HOME.'/
forum/'.$theme['forum_id'].'/'.
$theme['forumc_id'].'/'.$theme
['id'].'/?p='.$page.'">[>>]</a></
li>';
[93] echo CLOSE_DIV;
}
?>

Изм. 2 раз. / Посл. изм.

Blood Rayne

0.04

(26 май 2015, 04:20)

VarrkaN

0.35

(25 май 2015, 17:31) [0/0] [0] [отв] [спам] [под] +1 | -1

Blood Rayne,текст ошибки?

HOMER_1

2.1

(25 май 2015, 17:47) [1/0] [1] [отв] [спам] [под] +1 | -1

а тебя подробнее не учили писать?

Blood Rayne

0.04

[автор] (26 май 2015, 04:22) [0/0] [0] [отв] [спам] [под] +1 | -1

VarrkaN,

обновлен пост выше

Енот

16.13

(26 май 2015, 04:24) [0/0] [0] [отв] [спам] [под] +1 | -1

А на форуме есть эти 5 тем?
========

<?

$adm_add2=NULL;
if (!isset($user) || $user['level']==0){
$q222=mysql_query("SELECT * FROM `forum_f` WHERE `adm` = '1'";
while ($adm_f = mysql_fetch_assoc($q222))
{
$adm_add[]="`id_forum` <> '$adm_f[id]'";
}
if (sizeof($adm_add)!=0)
$adm_add2=' WHERE'.implode(' AND ', $adm_add);
}
///////////////////////////////////настройка сколько показывать тем на главной ////////////////////////////////
$kol="5";
echo "<table class='post'>\n";
$q=mysql_query("SELECT * FROM `forum_t`$adm_add2 ORDER BY `time` DESC LIMIT $kol";

while ($them = mysql_fetch_assoc($q))
{

$forum=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_f` WHERE `id` = '$them[id_forum]' LIMIT 1");
$razdel=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_r` WHERE `id` = '$them[id_razdel]' LIMIT 1");
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1");

echo " <tr>\n";

echo " <td class='icon14'>\n";
echo "<img src='/style/themes/$set[set_them]/forum/14/them_$them[up]$them[close].png' alt='' />";
echo " </td>\n";

echo " <td class='p_t'>\n";
echo "<a href='/forum/$forum[id]/$razdel[id]/$them[id]/'>$them[name] (".mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = '$forum[id]' AND `id_razdel` = '$razdel[id]' AND `id_them` = '$them[id]'",0)."</a>\n";
$post=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_p` WHERE `id_them` = '$them[id]' AND `id_razdel` = '$razdel[id]' AND `id_forum` = '$forum[id]' ORDER BY `time` DESC LIMIT 1");
$ank2=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1");
echo " <div style='float:right'><a href='/info.php?id=$ank2[id]' title='Последний \"$ank2[nick]\"'><font color='#008000'>$ank2[nick]</font></a></div> <br />\n";
echo " </td>\n";
echo " </tr>\n";

}
echo "</table>\n";

?>