$result = dbquery("SELECT *, IF(news_datestamp>'".$lastvisited."',1,0) AS new FROM ".DB_NEWS." WHERE news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10"); if (dbrows($result)) { if ($res == 0) { echo "
".$locale['403']." \n"; echo "".$locale['402']." $nrows | \n\n";
while ($data = dbarray($result)) {
echo THEME_BULLET." ".$data['news_subject']." ".($data['new'] == '1' ? "NEW!" : "")." \n"; } |