$razdelq=$db->query("SELECT * FROM `forum_razdel`");
while($razdel = $razdelq->fetch_assoc()){
echo '<div class="title">'.$razdel['name'].'</div>';
$subq = $db->query("SELECT * FROM `forum_subrazdel` WHERE `razdel` = '".$razdel['id']."'");
while($sub = $subq->fetch_assoc()){
$numt = $db->query("SELECT * FROM `forum_topics` WHERE `sub` = '".$sub['id']."'")->num_rows;
echo '<a href="forum/'.$sub['id'].'"><div class="block">'.$sub['name'].'('.$numt.')</div></a>';
}
}
$razdelq=$db->query("SELECT * FROM `forum_razdel`");
while($razdel = $razdelq->fetch_assoc()){
echo '<div class="title">'.$razdel['name'].'</div>';
$subq = $db->query("SELECT * FROM `forum_subrazdel` WHERE `razdel` = '".$razdel['id']."'");
while($sub = $subq->fetch_assoc()){
$numt = $db->query("SELECT * FROM `forum_topics` WHERE `sub` = '".$sub['id']."'")->num_rows;
echo '<a href="forum/'.$sub['id'].'"><div class="block">'.$sub['name'].'('.$numt.')</div></a>';
}
}