function displayNews($all = 0) {
global $db, $max_items;

if ($all == 0) {
 $query = "SELECT id, title, newstext, date_format(postdate, \'%Y-%m-%d\') as date
  FROM news
  ORDER BY postdate DESC
  LIMIT $max_items";
} else {
  $query = "SELECT id, title, newstext, date_format(postdate, \'%Y-%m-%d\') as date
  FROM news
  ORDER BY postdate DESC";
 }

if (!($result = mysql_query($query, $db))) {
 exit('MySQL Query Error: ' . mysql_error() . ' | SQL Query: ' . $query . ' | Line: ' . __LINE__);
}

while ($row = mysql_fetch_assoc($result)) {
 $date = $row['date'];
 $title = htmlentities($row['title']);
 $news = nl2br(strip_tags($row['newstext'], '<a><b><i><u>'));
 
 echo "<table border=\"1\" width=\"300\" align=\"center\">\n";
 echo "<TR><TD><b>$title</b> posted on $date</td></tr>\n";
 echo "<TR><TD>$news</td></tr>\n";
 
 $comment_query = "SELECT count(*)
  FROM news_comments
  WHERE news_id={$row['id']}";
 
 if (!($comment_result = mysql_query($query, $db))) {
  exit('MySQL Query Error: ' . mysql_error() . ' | SQL Query: ' . $comment_query . ' | Line: ' . __LINE__);
 }
 
 $comment_row = mysql_fetch_row($comment_result);
 
 echo "<TR><TD><a href=\"{$_server['php_self']}"."?action=show&amp;id={$row['id']}\">Comments</a>"."($comment_row[0]}</td></tr>\n";
 echo "</table>\n";
 echo "<br>\n";
}

if ($all == 0 ) {
 echo "<a href=\"{$_server['php_self']}?action=all\">View all news</a>\n";
}
}