DarkShade, shaxsiy cms yaratish mavzusiga o'ting
1.5666666666667 daqiqa sekund dan so'ng qo'shdi...
SamanHusan, <?php
echo '<div class="phdr"><b>Kutubhona bo`limlari</b></div>';
$sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` ASC");
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_cats` WHERE `parent`=0"), 0);
$y = 0;
if ($total) {
while ($row = mysql_fetch_assoc($sql)) {
$y++;
echo '<div class="menu"><a href="library/index.php?do=dir&amp;id=' . $row['id'] . '"> <img src="/img/green.png" alt="icon" width="14" height="14"/> ' . functions::checkout($row['name']) . '</a> <div class="" style="float:right;"> <span class="time">[' . mysql_result(mysql_query("SELECT COUNT(*) FROM `" . ($row['dir'] ? 'library_cats' : 'library_texts') . "` WHERE " . ($row['dir'] ? '`parent`=' . $row['id'] : '`cat_id`=' . $row['id'])), 0) . ']</span></div></div>';
}
}
?>