rendered paste body<?php
include "./mysql.php";
?>
<h1>News</h1>
<?php
$connection = db_connect();
$newsres = mysql_query("SELECT * FROM `news` ORDER BY `date` DESC LIMIT 0,30");
echo mysql_error();
while ($news = mysql_fetch_array($newsres))
{
echo "<div class='newsarticle'>";
echo "<p class='writetime'>({$news['date']})</p>";
echo "<h2>{$news['title']}</h2>";
echo "<p class='article'>{$news['article']}</p>";
$commentsres[$news['id']] = mysql_query("SELECT * FROM `comments` ORDER BY `time` ASC");
echo mysql_errno() . ":" . mysql_error() ."<br />";
if(mysql_num_rows($commentsres) == 0)
{
echo "<p class='nocomment'>There are no comments for this article.</p>";
}
echo "</div>";
}
?>