Форум: "; $lim = 20; $query = "SELECT * FROM main_forum ORDER by position LIMIT $lim "; $result = mysql_query ($query) or die ("Query failed1"); while ( $row = mysql_fetch_array ($result) ): $query_forum = "SELECT * FROM name_forum where id_main_forum =".$row['id']; $res_forum = mysql_query ($query_forum) or die ("Query failed2"); if(!$res_forum) exit(mysql_error()); $row_forum = mysql_fetch_array($res_forum); //dвыводим темы if($row_forum['id_forum'] !== NULL){ $query_theme = "SELECT * FROM themes where id_forum =".$row_forum['id_forum']; $res_theme = mysql_query ($query_theme) or die (mysql_error()); if(!$res_theme) exit(mysql_error()); $row_theme = mysql_fetch_array($res_theme); //выводим топики if($row_theme['id_theme'] !== NULL){ $queryasd = "SELECT id_post FROM posts where id_theme =".$row_theme[id_theme]; $res = mysql_query ($queryasd) or die ("Query failed4".mysql_error()); if(!$res) exit(mysql_error()); $resultasd = mysql_num_rows($res); } else{ $resultasd=0; } } else{ $resultasd=0; } print "
$row[name] $resultasd
"; $ids=$row[id]; endwhile; echo ""; include('switchforum.php'); /* $query1 = "SELECT * FROM main_forum ORDER by position LIMIT $lim "; $result1 = mysql_query ($query1) or die ("Query failed"); print"
"; */ ?>