[cit]
<?php

echo '<div class="phdr"><b>Категории книг</b></div>';

$sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` ASC"smile;

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_cats` WHERE `parent`=0"smile, 0);

if ($total) {

while ($row = mysql_fetch_assoc($sql)) {

echo '<div class="list' . (++$i % 2 ? 2 : 1) . '">'

. '<a href="library/index.php?do=dir&amp;id=' . $row['id'] . '">' . functions::checkout($row['name']) . '</a> ('

. mysql_result(mysql_query("SELECT COUNT(*) FROM `" . ($row['dir'] ? 'library_cats' : 'library_texts') . "` WHERE " . ($row['dir'] ? '`parent`=' . $row['id'] : '`cat_id`=' . $row['id'])), 0) . ')';



if (!empty($row['description'])) {

echo '<div style="font-size: x-small; padding-top: 2px"><span class="gray">' . functions::checkout($row['description']) . '</span></div>';

}

echo '</div>';

}

}



?>
[/cit]