Question

discuz数据库调用

SELECT a.*,b.* FROM pre_forum_thread as a left join pre_forum_forum as b on a.fid=b.fid order by tid desc
这段是调用discuz 板块名称+标题，是调用全部板块的
--------------------------------------------------------------------
我想调用指定的板块，比如fid>40的板块，要怎么修改，格式还是 板块名称+标题

Answer 1

SELECT a.*,b.* FROM pre_forum_thread as a inner join pre_forum_forum as b on a.fid=b.fid
where a.fid>40 order by tid desc

追问

不错，我在问下啊
如果是fid>40，排除其中的50.51板块，该怎么写啊

追答

SELECT a.*,b.* FROM pre_forum_thread as a inner join pre_forum_forum as b on a.fid=b.fid
where a.fid>40 and a.fid!=50 and a.fid!=51 order by tid desc