$result = dbquery("SELECT * 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 "\n"; } $nrows = dbcount("(news_id)", DB_NEWS, "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'"); echo "\n\n
".$locale['403']."
\n"; echo "".$locale['402']." $nrows
\n"; while ($data = dbarray($result)) { echo THEME_BULLET." ".$data['news_subject']."
\n"; }