Yangilik katagoriyasidagi id 2 bo`limga shu kodni tug`rilab berilar iltimos.
 
<?php
##BY Hujandiy FOR (UzFor.Net) 2016 (c) ##
 
$uzf = mysql_query("SELECT * FROM `main`;");
$lol = array();
while ($res = mysql_fetch_row($uzf)) $lol[$res[0]] = $res[1];
mysql_result($uzf);
$status = $lol['status'];
$ulimit = $lol['ulimit'];
$amatn = $lol['amatn'];
$bolim = $lol['cat'];
$oncat = $lol['oncat'];
$onid = $lol['onid'];
$cuser = $lol['cuser'];
$notfound = $lol['notfound'];
if($status == 1) {
echo '<div class="phdr"><b><span class="green">Bizning Kuboklar </span></b></div>';
if($oncat OR $onid == 2) {
$news_connect = mysql_query("SELECT * FROM `cms_news` WHERE `refid` = '2' AND `user_id` = '2' ORDER BY `time` DESC LIMIT 2");
} else {
$news_connect = mysql_query("SELECT * FROM `cms_news` ORDER BY `time` DESC LIMIT $ulimit");
}
while($here=mysql_fetch_assoc($news_connect)) { 
$newsid = $here['id'];
$ntitle = $here['name'];
$getext = $here['text'];
$time = $here['time'];
$views = $here['views'];
$matn =substr($getext, 0,$amatn);
$comm = mysql_result(mysql_query("select count(*) from `cms_news_comments` where `refid` = '".$row['id']."'"), 0); 
 
 echo'<div class="menu"><b><span class="newsTime time bottom">'. date ('H:i', $here['time']+$sdvigclock*3600) .'</span></b><a href="news/index.php?act=view&id='.$newsid.'">
'. htmlentities($ntitle,ENT_QUOTES,'UTF-8').'</a>('.$comm.') </div>';
if (file_exists(H . 'files/news/web_news_' . $row['id'] . '.png') !== false)
echo '<img style="float: left; margin: 5px 6px 2px 2px; border: 0px;" src="' . $set['homeurl'] . '/files/news/web_news_' . $row['id'] . '.png" width="120" height="100" alt="" />';
echo '<div style="clear:both;"></div>';
echo '</div>'; 
 
 
}
}
 
 
 
bu kodni esa yangilik katagoriyasidai id 3 bo`limga tug`rilashga yordam beringlar!
 
<?php
##BY Hujandiy FOR (UzFor.Net) 2016 (c) ##
 
$uzf = mysql_query("SELECT * FROM `main`;");
$lol = array();
while ($res = mysql_fetch_row($uzf)) $lol[$res[0]] = $res[1];
mysql_result($uzf);
$status = $lol['status'];
$ulimit = $lol['ulimit'];
$amatn = $lol['amatn'];
$bolim = $lol['cat'];
$oncat = $lol['oncat'];
$onid = $lol['onid'];
$cuser = $lol['cuser'];
$notfound = $lol['notfound'];
if($status == 1) {
echo '<div class="phdr"><b>Bizning Chempionlar</b></div>';
if($oncat OR $onid == 2) {
$news_connect = mysql_query("SELECT * FROM `cms_news` WHERE `refid` = '$bolim' AND `user_id` = '$cuser' ORDER BY `time` DESC LIMIT $ulimit");
} else {
$news_connect = mysql_query("SELECT * FROM `cms_news` ORDER BY `time` DESC LIMIT $ulimit");
}
while($here=mysql_fetch_assoc($news_connect)) { 
$newsid = $here['id'];
$ntitle = $here['name'];
$getext = $here['text'];
$time = $here['time'];
$views = $here['views'];
$matn =substr($getext, 0,$amatn);
 
 
 
 
 
 echo'<div class="menu"><b><span class="newsTime time bottom">'. date ('H:i', $here['time']+$sdvigclock*3600) .'</span></b><a href="news/index.php?act=view&id='.$newsid.'">
'. htmlentities($ntitle,ENT_QUOTES,'UTF-8').'</a></div>';
if (file_exists(H . 'files/news/web_news_' . $row['id'] . '.png') !== false)
echo '<img style="float: left; margin: 5px 6px 2px 2px; border: 0px;" src="' . $set['homeurl'] . '/files/news/web_news_' . $row['id'] . '.png" width="120" height="100" alt="" />';
echo '<div style="clear:both;"></div>';
echo '</div>'; 
 
 
}
}