Просмотр поста

$quiz = '1';
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `refid`='$quiz'"), 0);
echo '<div class="phdr"><b>Викторины сайта</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="60" height="60" style="border-radius: 59px; border: 3px solid whitesmoke;" alt="loyiha"/>';}else{
echo'<img src="'.$home.'/images/site_icons/home_news.png" width="60" height="60" style="border-radius: 59px; 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" width="16" height="16" alt="fikrlar"/> ' . mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='" . $row['id'] . "'"), 0) . '</td></tr>';
echo ' <tr><td><span class="jamoa"><img src="'.$home.'/images/site_icons/add_author.png" width="14" height="14" alt="yangilik avtori"/> '.$name_use . '&nbsp;&nbsp;<img src="'.$home.'/images/site_icons/date.png" width="14" height="14" alt="sana"/> ' . date('d.m.y , H:i', $row ['time']) . '&nbsp;&nbsp;<img src="'.$home.'/images/site_icons/view.png" width="14" height="14" alt="views"/>'. $row['count'] .'</span></td></tr></table>';
echo'</div>';
  $i;
}
echo '<div class="menu"><a href="'.$home.'/news/index.php?id='.$quiz.'">»Все викторины сайта</a> ('.$count.')</div>';