$num_of_news_items = 5;



$result = dbquery(

   "SELECT tn.*, tc.*, user_id, user_name, user_status FROM ".DB_PREFIX."news tn

   LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id

   LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id

   WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")

   ORDER BY news_sticky DESC, news_datestamp DESC LIMIT 0,".$num_of_news_items

);



$i = 0;



echo "<table align='center' cellpadding='0' cellspacing='5' width='100%'>\n";

while ($data = dbarray($result)) {

   $news_subject = stripslashes($data['news_subject']);

   $news_info = array(

      "news_id" => $data['news_id'],

      "user_id" => $data['user_id'],

      "user_name" => $data['user_name'],

      "user_status" => $data['user_status'],

      "news_date" => $data['news_datestamp'],

      "news_ext" => $data['news_extended'] ? "y" : "n",

      "news_reads" => $data['news_reads'],

      "news_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data['news_id']."'"),

      "news_allow_comments" => $data['news_allow_comments']

   );

   $news_cat_image = "";

   if ($data['news_cat_image']) {

      $news_cat_image = "<a href='news_cats.php?cat_id=".$data['news_cat_id']."'><img src='".IMAGES_NC.$data['news_cat_image']."' alt='".$data['news_cat_name']."' align='left' style='border:0px;margin-top:3px;margin-right:5px' /></a>";

   } else {

      $news_cat_image = "";

   }

   $news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);

   if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;

   echo "<tr>\n<td valign='top' class='tbl1 border'><div style='text-align:center; font-weight:bold; color:#04678C;' class='tbl2 show_item'>".$news_subject."</div>\n";

   echo "<div ".($i != 0 ? "class='news_display'" : "")." style='width:100%;'>\n<br />".$news_news."<br /><br />

   <div style='text-align:center;' class='tbl2'>".newsposter($news_info," &middot;").newsopts($news_info,"&middot;").itemoptions("N",$news_info['news_id'])."</div>\n</div>\n</td>\n</tr>\n";

   $i++;

}

echo "<tr>\n<td valign='top' class='tbl1 border'><div style='text-align:center; font-weight:bold;' class='tbl2'><a href='".BASEDIR."news.php'>Alle nyheder</a></div>\n</td>\n</tr>\n</table>\n";