$pres = dbquery( "SELECT news_id FROM ".$db_prefix."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND (news_datestamp<".$data['news_datestamp'].") ORDER BY news_datestamp DESC, news_id DESC LIMIT 1" ); $nres = dbquery( "SELECT news_id FROM ".$db_prefix."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND (news_datestamp>".$data['news_datestamp'].") ORDER BY news_datestamp ASC, news_id DESC LIMIT 1" ); if (dbrows($pres)) $prev = dbarray($pres); if (dbrows($nres)) $next = dbarray($nres); if ((isset($prev['news_id']) && isNum($prev['news_id'])) || (isset($next['news_id']) && isNum($next['news_id']))) { if (isset($prev)) [color=green]$previous = "\n";[/color] if (isset($next)) [color=olive]$nextt = "\n";[/color] }