Qobilov_Sardor
TimX, # TimX (07.09.2020 / 13:40)
Sardor, Hammasini chiqaradigan kodni tashlang, sozlab beraman
Kod · PHP39 qator
<?php



echo '<div class="phdr">Yangiliklar</div>';

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `refid`= 1"), 0);

$kmess ='4';

if ($total) {

$req = mysql_query("SELECT * FROM `cms_news` WHERE `refid`= 1 ORDER BY `time` DESC LIMIT ".$start.", ".$kmess);

while($trans_res= mysql_fetch_array($req)){

$comm= mysql_result( mysql_query("select count(*)  from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0);



echo '<div class="menu"><span class="list1">'.(date('H:i ',$trans_res['time'])).'</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'"><font color="#454545">'. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</font></a> <a class="cm orang"> ' . $comm . '</a></div></div>';



++$i;

}

}

if ($total > $kmess) {

echo '<div class="menu"><center>' . functions::display_pagination('?', $start, $total, $kmess) . '</center></div>';

}



?>


mana shu.