Mavzu: JohnCms Da Bosh sahifaga chiqarish
274. u2b3ki (279) [off]
|
TXT |
13| 4 Sep 2017, 12:50
uzmastersuzmasters (4 Sep 2017, 11:16):
REYXAN, yoki mana bu
$tasodifiy = mysql_query("SELECT * FROM `library_texts` WHERE `premod` = '1' ORDER BY RAND() LIMIT 1");
while ($tasodif = mys• • •
RARE, order by rand emas time qilish kerak eng oxirgi malumotlar chiqadi agar activ qilsa eng kop oqilganlari chiqadi
275. REYXAN (1461) [off]
|
TXT |
13| 4 Sep 2017, 12:57
#267, yordam. //oldin bilardim xozr esimda yo'q,
276. u2b3ki (279) [off]
|
TXT |
13| 4 Sep 2017, 13:00
REYXAN (4 Sep 2017, 11:08):
Kutubhonadagi xoxlagan kategoriyadagi maqolani bosh sahifaga chiqarish kerak,
REYXAN, order by rand limit 1 qilasiz
277. REYXAN (1461) [off]
|
TXT |
13| 4 Sep 2017, 13:03
u2b3ki (4 Sep 2017, 13:00):
REYXAN, order by rand limit 1 qilasiz
u2b3ki, men buni aytyapman libraryda 3,4.ta kategoriya bor
sherlar
latifalar
balo
battar
endi bularda maqola bor men aynan latifalardagi maqolani chiqarishim kerak
<?php
/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = '10';
echo '<div class="phdr"><b>Barselona yangiliklari</b></div>';
$bolm_sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC");
$sql = mysql_result(mysql_query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1'), 0);
$page = $page >= ceil($sql / $kmess) ? ceil($sql / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);
$req_lib = mysql_query("SELECT * FROM `library_texts` WHERE `premod`='1' ORDER BY `time` DESC LIMIT " . $start . "," . $kmess);
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo'<div class="list1">';
if (file_exists((ROOTPATH . 'files/library/images/big/' . $lib['id'] . '.png'))){
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
echo '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">';
}else{
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
}
echo ''
. '(' . functions::display_date($lib['time']) . ')<br/> <a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"><b>' . $lib['name'] . '</b></a><br />'
. '<img src="../koz.png" width="20" height="20" alt="»"/> ' . $lib['count_views'] . '</a>';
echo '</div>';
}
}
?>
278. uzmastersuzmasters (552) [off]
|
TXT |
13| 4 Sep 2017, 13:21
u2b3ki (4 Sep 2017, 12:50):
RARE, order by rand emas time qilish kerak eng oxirgi malumotlar chiqadi agar activ qilsa eng kop oqilganlari chiqadi
u2b3ki, men boshqa narsa yozdim
279. u2b3ki (279) [off]
|
TXT |
13| 4 Sep 2017, 20:51
REYXAN (4 Sep 2017, 13:03):
u2b3ki, men buni aytyapman libraryda 3,4.ta kategoriya bor
sherlar
latifalar
balo
battar
endi bularda maqola bor men aynan latifalardagi maqolan• • •
REYXAN, sizga kerakli bolimni id raqami nechchi?
280. u2b3ki (279) [off]
|
TXT |
13| 4 Sep 2017, 20:53
Yoki saytiz manzilini bering va qaysi bolim chiqishini eting))