[code]
<?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>';
}
}

?>
[/code]