Manashu ködni john 6
20ga qöysam sayt ishlamay qolyapti. Krite news qöyganman sqlsini zalit qiganman.
<? echo '<div class="phdr2"><b>So'ngi xabarlar</
b></div>';
$count= mysql_query("select count(*) from
`cms_news` where `time`<='". time()."'");
$total= mysql_result($count,0);
if($total>0)
$trans_req= mysql_query("select * from `cms_
news` where `time`<='". time()."' order by
`time` desc limit $start, $kmess;");
while($trans_res= mysql_fetch_array($trans_
req)){
echo '<div style="clear: both;"></div><div
class="news1">';
$comm= mysql_result( mysql_query("select
count(*) from `cms_news_comments` where
`refid` = '".$trans_res['id']."'"),0);
$ncount = mysql_fetch_array(mysql_query
("SELECT * FROM `cms_news` WHERE `id` ='$
id'"));
if (!isset($_SESSION['cms_news']) || isset($_
SESSION['cms_news'])&&$_SESSION['cms_
news'] != $id) {
$_SESSION['cms_news'] = $id;
$newscount = intval($ncount['count']) + 1;
mysql_query("UPDATE `cms_news` SET
`count` ='$newscount'WHERE `id` ='$id'");
}
if( file_exists('../files/news/news_'.$trans_res['id']
.'.png')!==false)
echo'<img style="float: left; margin: 5px 6px 2px
2px; border: 0px;" src="../files/news/news_'.$
trans_res['id'].'.png" alt=""/>';
$komm = mysql_result(mysql_query("SELECT
COUNT(*) FROM `cms_news_comments`
WHERE `refid`='{$res['id']}'"), 0);
echo '<span class="time">'. date('H:i',$trans_res
['time']+$sdvigclock*8600).'</span> <a href="/
news/index.php?act=view&id='.$trans_res['id']
.'"> '. htmlentities($trans_res['name'],ENT_
QUOTES,'UTF-8').'</a<br /> <font
color="olive">O`qildi: '. $trans_res['count'] .' -
Fikrlar: ' . $comm . '</font></div>';
++$i;
} ?>