[e:loop={"select tid,subject,dateline from Discuzdb.cdb_threads order by tid desc limit 10",10,24,0}] [/e:loop]
Discuzdb.cdb_threads为Discuz的贴子表名,其中“discuzdb”为Discuz的数据库名称。
limit 10为显示贴子数量。
如果用伪静态地址可以用:/bbs/thread--1-1.html
如果指定单个版块的贴子,SQL用:select tid,subject,dateline from discuzdb.cdb_threads where fid=版块IDorder by tid desc limit 10如果指定多个版块的贴子,SQL用:select tid,subject,dateline from discuzdb.cdb_threads where fid in (1,2,3)order by tid desc limit 10
[e:loop={"select tid,subject,dateline,fid from discuzdb.cdb_threads order by tid desc limit 10",10,24,0}]$fr=$empire->fetch1("select name from discuzdb.cdb_forums where fid='$bqr[fid]'");?>[/e:loop]
discuzdb.cdb_forums为Discuz的版块表名,其中“discuzdb”为Discuz的数据库名称。
[e:loop={"select tid,subject,postdate from phpwinddb.pw_threads order by tid desc limit 10",10,24,0}][/e:loop]
phpwinddb.pw_threads为phpwind的贴子表名,其中“phpwinddb”为phpwind的数据库名称。
limit 10为显示贴子数量。
如果用伪静态地址可以用:/bbs/read-htm-tid-.html
如果指定单个版块的贴子,SQL用:select tid,subject,postdate from phpwinddb.pw_threads where fid=版块ID order by tid desc limit 10如果指定多个版块的贴子,SQL用:select tid,subject,postdate from phpwinddb.pw_threads where fid in (1,2,3) order by tid desc limit 10
[e:loop={"select tid,subject,postdate,fid from phpwinddb.pw_threads order by tid desc limit 10",10,24,0}]$fr=$empire->fetch1("select name from phpwinddb.pw_forums where fid='$bqr[fid]'");?>[/e:loop]
phpwinddb.pw_forums为phpwind的版块表名,其中“phpwinddb”为phpwind的数据库名称。
新闻热点
疑难解答