Все категории
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `blogs_cat`;'), 0);
if($count>0) {
$res = mysql_query("SELECT * FROM `blogs_cat` ORDER BY `realid`;");
while ($row = mysql_fetch_assoc($res)) {
$counts = mysql_result(mysql_query("SELECT COUNT(*) FROM `blogs` WHERE `ref`='" . $row['id'] . "'".($rights > 7?'':' AND `mod`=0').";"), 0);
echo ($i % 2) ? '<div class="list2">' : '<div class="list1">';
echo '<a href="/blogs/index.php?id='.$row['id'].'">'.$row['name'].'</a> [' . $counts . ']';
echo '</div>';
++$i;
}
} else {
echo '<div class="menu">Категории не созданы</div>';
}