<?php $tasodifiy = mysql_query("SELECT * FROM `library_texts` WHERE `premod` = '1' ORDER BY RAND() LIMIT 1"); echo '<div class="bmenu"> » <font color= #FF0000 >Tasodifiy Maqola</font> : <a href="../library/index.php?id=' . $tasodif['id'] . '">'.$tasodif['name'].'</a><div>'.$tasodif['announce'].'<a href="../library/index.php?id=' . $tasodif['id'] . '"> Davomi...</a></div></div>'; } ?>
. Kim biladi nima qilsam bo'ladi? Yoki kimdadir ishlaydigan news modi bormi? Ishlaydigani bo'lsa tashlanglar, ichida .sql fayli bo'lsa ayni muddao. Categorya ochib bo'mayotganini sababi menimcha qaysidur ustun yoq bazada. Shunga news.sql xam kerak. Ijobiy mandan .gif)
. Kim biladi nima qilsam bo'ladi? Yoki kimdadir ishlaydigan news modi bormi? Ishlaydigani bo'lsa tashlanglar, ichida .sql fayli bo'lsa ayni muddao. Catview.php?act=post&id=70019 shu modni ozini ishlatsangiz ham boladi kategoriya uchun ichidagi sql.sql ni zalit qilsez kategoriya qowiladi. Sizdagi modga tablitsa qowilmagan
// news echo '<div class="header"><b>So\'ngi xabarlar</b></div>'; if($total>0) $trans_req= mysql_query("select * from `cms_news` where `time`<='". time()."' order by `time` desc limit $start, $kmess;"); $comm= mysql_result( mysql_query("select count(*) from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0); $_SESSION['cms_news'] = $id; } $komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='{$res['id']}'"), 0); echo '<div class="yangilik">'; echo '<span class="newsTime time bottom">' . date('H:i', $trans_res['time'] (core::$system_set['timeshift'] core::$user_set['timeshift']) * 3600) . '</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'"> '. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</a> <img style="vertical-align: middle ! important;" src="/images/blue_comment.png" /> ' . $comm . '</div>'; $i; } if($total>$kmess){ echo'<div class="yangilik" align="center"><p>'. functions::display_pagination('index.php?id='.$id.'&',$start,$total,$kmess).'</p></div>'; }
// news echo '<div class="header"><b>So\'ngi xabarlar</b></div>'; if($total>0) $kmess=4 $trans_req= mysql_query("select * from `cms_news` where `time`<='". time()."' order by `time` desc limit $kmess;"); $comm= mysql_result( mysql_query("select count(*) from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0); $_SESSION['cms_news'] = $id; } $komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='{$res['id']}'"), 0); echo '<div class="yangilik">'; echo '<span class="newsTime time bottom">' . date('H:i', $trans_res['time'] (core::$system_set['timeshift'] core::$user_set['timeshift']) * 3600) . '</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'"> '. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</a> <img style="vertical-align: middle ! important;" src="/images/blue_comment.png" /> ' . $comm . '</div>'; $i; } if($total>$kmess){ echo'<div class="yangilik" align="center"><p>'. functions::display_pagination('index.php?id='.$id.'&',$start,$total,$kmess).'</p></div>'; }
.gif)
Uning ucun baza tablitsasiga ustun qowiw kerak
// news echo '<div class="header"><b>So\'ngi xabarlar</b></div>'; if($total>0) $kmess=4 $trans_req= mysql_query("select * from `cms_news` where `time`<='". time()."' order by `time` desc limit $kmess;"); $comm= mysql_result( mysql_query("select count(*) from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0); $_SESSION['cms_news'] = $id; } $komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='{$res['id']}'"), 0); echo '<div class="yangilik">'; echo '<span class="newsTime time bottom">' . date('H:i', $trans_res['time'] (core::$system_set['timeshift'] core::$user_set['timeshift']) * 3600) . '</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'"> '. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</a> <img style="vertical-align: middle ! important;" src="/images/blue_comment.png" /> ' . $comm . ' - oqildi '.$trans_res['reads'].' </div>'; $i; } if($total>$kmess){ echo'<div class="yangilik" align="center"><p>'. functions::display_pagination('index.php?id='.$id.'&',$start,$total,$kmess).'</p></div>'; }