$quiz = '1';
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `refid`='$quiz'"), 0);
echo '<div class="phdr"><b>Sayt yangiliklari</b></div>';
$req = mysql_query("SELECT `id`, `name`, `img`, `text`, `time`, `user_id`, `refid`, `count` FROM `cms_news` where `refid` = '" . $quiz . "' ORDER BY `time` DESC LIMIT " . $start . ",". 5);
$i = 1;
while (($row = mysql_fetch_assoc($req)) !== false) {
$us = mysql_query("SELECT `id`, `name` FROM `users` WHERE `id` = '{$row['user_id']}'");if (mysql_num_rows($us)) {
$rowuse = mysql_fetch_assoc($us);$name_use = $user_id ? '<a href="../users/profile.php?user=' . $rowuse['id'] . '"><b>' . $rowuse['name'] . '</b></a>' : $rowuse['name'];} else {$name_use = $lng['guest'];}
echo '<div class="chats"><table><tr><td rowspan=2 style="width: 65px;">';if(!empty($row['img'])) {echo'<img src="'.$row['img'].'"  width="50" height="50" style="border-radius: 50px; border: 3px solid whitesmoke;" alt="loyiha"/>';}
else{echo'<img src="'.$home.'/images/site_icons/home_news.png" width="50" height="50" style="border-radius: 50px; border: 3px solid whitesmoke;" alt="loyiha"/>';}
echo'</td>';
echo'<td><a href="' . $set['homeurl'] . '/news/index.php?act=view&amp;id=' . $row['id'] . '"> ' . htmlentities($row['name'], ENT_QUOTES, 'UTF-8') . '</a> 
<img src="'.$home.'/images/site_icons/izoh.png" class="icon-inline" width="14" height="14" alt="fikrlar"/>'.mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='".$row['id']."'"), 0).'</td></tr>';
echo ' <tr><td style="icon-inline"><img src="'.$home.'/images/site_icons/add_author.png" width="12" height="12" alt="yangilik avtori" /> '.$name_use . '&nbsp;&nbsp;<img src="'.$home.'/images/site_icons/date.png" width="12" height="12" alt="sana"/> ' . date('H:i', $row ['time']) . '&nbsp;
 <img src="'.$home.'/images/site_icons/view.png" width="11" height="11" alt="views"/> '. $row['count'] .'
</td></tr></table>';
echo'</div>';  $i;}
echo '<div class="menu"><a href="'.$home.'/news/index.php?id='.$quiz.'">»Barcha sayt loyihalari</a> ('.$count.')</div>';