Файл: sys/inc/news_main.php
Строк: 23
<?
$q = mysql_query("SELECT * FROM `news` WHERE `main_time` > '".time()."' ORDER BY `id` DESC LIMIT 1");
if (mysql_num_rows($q) == 1)
{
$news = mysql_fetch_assoc($q);
echo '<div class="mess">';
echo '<img src="/style/icons/rss.png" alt="*" /> <a href="/news/news.php?id=' . $news['id'] . '">' . text($news['title']) . '</a> ';
echo '(' . vremja($news['time']) . ')<br />';
echo output_text($news['msg']) . '<br />';
if ($news['link']!=NULL)
echo '<a href="' .htmlentities($news['link'], ENT_QUOTES, 'UTF-8').'">Подробности</a><br />';
echo '<img src="/style/icons/komm.png" alt="*" /> (' . mysql_result(mysql_query("SELECT COUNT(*) FROM `news_komm` WHERE `id_news` = '$news[id]'"),0) . ')<br />';
echo '</div>';
}
?>