$start = ($curpage-1)*$perpage; ' e5 A) T T1 f. y$ F2 a: K) W; {
$askcount = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('forum_thread')." WHERE fid = '2' AND authorid > 1"));/ y' U) b3 W) q6 p/ F, {
//$asklist 6 X* E* N8 Z$ h7 o1 [ H5 f$ R
$asklist = array(); 0 _! e4 X& R/ `( y" Z) s/ N
if ($askcount) { ?" F. i+ L9 y' {
$query = DB::query("SELECT * FROM ".DB::table('forum_thread')." WHERE fid = '2' AND displayorder > -1 ORDER BY tid ASC LIMIT $start,$perpage");0 T7 T% a2 K7 N- v0 k0 e8 C+ Z: e
while ($value = DB::fetch($query)) { - g% J# _* o, n5 A+ A7 P
$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] ); . v G5 H0 |. a+ ]- W2 }! b. R
$start = ($curpage-1)*$perpage; 8 n% |$ \7 }' ~
$acount = DB::result(DB::query("SELECT count(*) FROM ".DB::table('forum_forum')." b LEFT JOIN ".DB::table('forum_forumfield')." bf ON bf.fid=b.fid WHERE b.type='sub' AND b.status = 3 AND bf.icon != ''"));' Q6 h' N- m$ \9 b) K6 |. K2 j' _
//$alist # T0 w, ?" |7 e# l- m6 e2 J' w
$alist = array();; y6 N% |5 h6 H0 p: @& v
if ($acount) { . o, f3 ]- n6 [. r3 [- K
$query = DB::query("SELECT bf.*, b.* FROM ".DB::table('forum_forum')." b LEFT JOIN ".DB::table('forum_forumfield')." bf ON bf.fid=b.fid WHERE b.type='sub' AND b.status = 3 AND bf.icon != '' ORDER BY bf.shoplevel DESC, b.commoncredits DESC, bf.fid DESC LIMIT $start,$perpage"); + r. l7 K, F! ?6 y/ ~
while ($value = DB::fetch($query)) {* H! C6 J8 H$ c1 x' C* M
<!--{eval $biaoid = substr($value[tid], -1); $cover = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_attachment_'.$biaoid.'')." WHERE tid = '$value[tid]'"));}-->
复制代码
数据库循环嵌套调用:
<!--{eval $slides = DB::fetch_all("SELECT * FROM ".DB::table('a')." WHERE `uid`= $_G[uid] ORDER BY `id` DESC");}--> $ X2 h# Y: g, N8 D* S% e$ w