opentable("Nyheder");

$result = dbquery("SELECT * FROM ".DB_NEWS." 

LEFT JOIN ".DB_NEWS_CATS." ON news_cat=news_cat_id

WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0,10");

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

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

$title = $data['news_subject'];

$sh_title = $title;

$n_id = $data['news_id'];

$v_id = $data['news_reads'];

$c_id = $data['news_cat_name'];

$comments_n = dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id=$n_id");

$date = $data['news_datestamp'];

$n_date = showdate("%d-%m-%Y", $date);

echo "<tr><td class='tbl' style='border-top:1px #ccc dotted;'> <img src='".THEME."images/bullet.gif' alt='' /> $n_date | <a href='news_cats.php?cat_id=".$data['news_cat_id']."' title='".$data['news_cat_name']."'>$c_id</a> - <a href='news.php?readmore=$n_id'><b>$sh_title</b></a> [Lęst $v_id gange]</td></tr>\n";



}

echo "<tr><td align='center' class='tbl' style='border-top:1px #ccc dotted;'><a href='".BASEDIR."news.php'>Alle Nyheder</a> - <a href='".BASEDIR."nyhedsarkiv.php'>Nyhedsarkivet</a></td>



</tr>\n";

echo "</table>\n";

closetable();