744. uZaFaRaP (405) [off]
|
TXT |
35| 21 Dec 2018, 20:36
Besthakker (5 Dec 2018, 10:40):
Librarydagi bolimlarni bosh sahifaga chiqaruvchi kodni aytib yuborizlar
Besthakker, echo'<div class="header"><b>Kutubxona bo'limlari</b></div>';
$kutubxona_bolim = mysql_query("SELECT * FROM `library_cats` ORDER BY `id` DESC LIMIT 20");
while ($bolim = mysql_fetch_assoc($kutubxona_bolim)) {
$maqola = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `cat_id` = '".$bolim['id']."';"), 0);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `time` > '".(time() - 86400)."' AND `cat_id` = '".$bolim['id']."';"), 0);
echo'<div class="menu"><img src="/images/papka.png"> <a href="/library/index.php?do=dir&id='.$bolim['id'].'"><b>'.$bolim['name'].'</a> ['.$maqola.'';
if ($new > 0) {
echo '<font color="red"> </font>';
}
echo ']</b></div>';
}