以下是SQL语句:
select a.tid,a.subject,a.typeid,a.subject as subjectall,a.dateline,b.name from discuz.cdb_threads a left join discuz.cdb_threadtypes b on b.typeid=a.typeid where a.fid=231 order by a.dateline desc
以下是生成了的,并调用的代码:
<!--{block name="bbsthread" parameter="sql/SELECT%20a.tid%2Ca.subject%2Ca.typeid%2Ca.subject%20as%20subjectall%2Ca.dateline%2Cb.name%20from%20discuz.cdb_threads%20a%20left%20join%20discuz.cdb_threadtypes%20b%20on%20b.typeid%3Da.typeid%20where%20a.fid%3D232%20order%20by%20a.dateline%20desc%20limit%200%2C9/cachetime/900/subjectlen/32/bbsurltype/bbs/cachename/val0/tpl/data"}--><!--房屋信息-->
<!--{loop $_SBLOCK['val0'] $value}-->
<li><div style="float:left"><font style="width:60px">【<a href="http://bbs.07430743.com/forumdisplay.php?fid=232&filter=type&typeid=$value[typeid]" style="color:#ff0000" target="_blank">$value[name]</a>】</font><a href="http://bbs.07430743.com/viewthread.php?tid=$value[tid]" target="_blank" title="$value[subjectall]">$value[subject]</a></div><font color="#888888" style="float:right">#date("m-d", $value["dateline"])#</font></li>
<!--{/loop}-->
版本5没问题
版本6到现在08年2月21号今天都还是不行,看了很多贴,都没有这方面的资料 |