1.從數(shù)據(jù)庫中取6個(gè)值，這些值中的字段可以隨意調(diào)出。
<!--{eval
$threads = DB::fetch_all("SELECT * FROM `pre_forum_thread` ORDER BY dateline DESC LIMIT 0,6");
}-->
可以使用loop語句輸出這些由字段組成的值。
<!--{loop $threads $value}-->
<p class="news">
<em>{echo date('d日',$value[dateline])} | </em>
<a href="t$value[tid].html">$value[subject]</a>
</p>
<!--{/loop}-->
2.增加篩選條件：取pre_portal_article_title表中 catid 介于50到59之間，或66到74之間的值，然后按照時(shí)間倒序排列。
<!--{eval
$app = DB::fetch_all("SELECT * FROM `pre_portal_article_title` WHERE catid BETWEEN 50 AND 59 OR catid BETWEEN 66 AND 74 ORDER BY dateline DESC LIMIT 0,9");
}-->
3.另一種數(shù)據(jù)庫查詢方法:通過這種查詢獲得的變量可以在其作用范圍內(nèi)直接使用。
<!--{eval
$usernum = DB::result_first("SELECT count(*) FROM ".DB::table('common_member'));
$onlinenum = DB::result_first("SELECT count(*) FROM ".DB::table('common_session'));
$todayposts = DB::result_first("SELECT sum(todayposts) FROM ".DB::table('forum_forum')." WHERE status=3");
$yesterdayposts = DB::result_first("SELECT sum(yesterdayposts) FROM ".DB::table('forum_forum')." WHERE status=3");
$threads = DB::result_first("SELECT sum(threads) FROM ".DB::table('forum_forum')." WHERE status=3");$posts = DB::result_first("SELECT sum(posts) FROM ".DB::table('forum_forum')." WHERE status=3");
$groups = DB::result_first("SELECT count(*) FROM ".DB::table('forum_forum')." WHERE type='sub'");
$record = DB::result_first("SELECT svalue FROM ".DB::table('common_setting')." WHERE skey='onlinerecord'");
$maxrecord = explode(" ",$record);}-->
