回复 huashi3483 的帖子
问下:- WHERE f.status IN ('1','2')and (f.fid in (36,37) or f.fup in (36,37))ORDER BY f.type, f.displayorder"
- : "SELECT f.fid, f.fup, f.type, f.name, f.threads, f.posts, f.todayposts, f.lastpost, f.inheritedmod,
- f.forumcolumns, f.simple, ff.description, ff.moderators, ff.icon, ff.viewperm, ff.redirect, ff.extra
- FROM ".DB::table('forum_forum')." f
- LEFT JOIN ".DB::table('forum_forumfield')." ff USING(fid)
- WHERE f.status IN ('1','2')and (f.fid in (36,37) or f.fup in (36,37))ORDER BY f.type, f.displayorder";
复制代码 为什么我改后还是不行呢?能帮我看下哪里出错了??? |