Хора къде греша с този код
Код:
$query_cat = "SELECT * FROM `" . $CATEGORIES_TABLE . "` order by cat_place ";
$query_c = mysql_query($query_cat);
while ( $red19 = mysql_fetch_array( $query_c )){
$catname = $red19['cat_name'];
$catid = $red19['cat_id'];
$count_q = "select * from " . $FORUMS_TABLE . " where cat_id='" . $catid . "'";
$result = mysql_query($count_q, $conn) or die(include "mysql_error.php");
$c_forums = mysql_num_rows($result);
for($i = 0; $i < $c_forums; ++$i){
$forums['name'] = mysql_result($result,$i,"forum_name");
$forums['place'] = mysql_result($result,$i,"forum_place");
$forums['id'] = mysql_result($result,$i,"forum_id");
$zaiavka_numt = "select * from " . $TOPICS_TABLE . " where forum_id='" . $forums['id'] . "'";
$result_numt=mysql_query($zaiavka_numt, $conn) or die(include "mysql_error.php");
$numt=mysql_num_rows($result_numt);
if ($numt != "0"){
$zaiavka_post = "select t.topic_name, t.forum_id, p.post_id, p.id, p.post_user_id, p.post_date
FROM " . $POSTS_TABLE . " p, " . $TOPICS_TABLE . " t
WHERE p.forum_id = '" . $forums['id'] . "' and t.topic_id = p.id order by post_id";
$rez_post = @mysql_query($zaiavka_post, $conn) or die(include "mysql_error.php");
$posts = mysql_fetch_array($rez_post);
$newtime = $posts['date'] + $differencetolocaltime*3600;
$vreme = date("M d, g:i", $newtime);
$dyljina = strlen($catname);
$broi_bukvi = "20";
if (strlen($lasttema)>$broi_bukvi)
{$totchki='...';}
else
{$totchki='';}
$lasttema=substr($lasttema,0 , $broi_bukvi);
$templatea->assign_block_vars('forumrow',array(
'CAT_NAME' => $catname,
'GROUP_NAME' => $group
));
}
}
}