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

$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"/> ' . functions::display_date($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>';