opentable("Flere nyheder");

$result = dbquery("SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_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 1,20"); 

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'];

$comments_n = dbcount("(comment_id)", "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'> $n_date | <a href='news.php?readmore=$n_id'><b>$sh_title</b></a> <i>Af <a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></i></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();