如何在PHPcms首页用get调用PHPwind论坛某一版块的最新帖子?要求标题带有地址链接!
研究一下,已经自己搞定
某版块最新10条正确表达:
{get dbsource="pw" sql="SELECT `tid`,`fid`,`author`,`subject`,`lastpost` FROM `pw_threads` WHERE `fid` = '13' ORDER BY `lastpost` DESC" rows="10" }
<li><a href="../PHPwind/read.PHP?tid-{$r[tid]}.html" }">{str_cut($r[subject],45)}</a></li>
{/get}
某版块精华10条正确表达:
{get dbsource="pw" sql="SELECT `tid`,`digest` FROM `pw_threads` WHERE `fid` = '13' ORDER BY `digest` DESC" rows="10" }
<li><a href="../PHPwind/read.PHP?tid-{$r[tid]}.html" }">{str_cut($r[subject],45)}</a></li>
{/get}
多个版块最新10条正确表达:
{get dbsource="pw" sql="SELECT `tid`,`lastpost` FROM `pw_threads` WHERE `fid`IN(3,22,26) ORDER BY `lastpost` DESC" rows="10" }
<li><a href="../PHPwind/read.PHP?tid-{$r[tid]}.html" }">{str_cut($r[subject],45)}</a></li>
{/get}