標題: 循環調用最新帖子，能加上帖子的簡介嗎？ [打印本頁] 作者: duoduobaba 時間: 2024-11-16 10:59 標題: 循環調用最新帖子，能加上帖子的簡介嗎？ <!--{eval $slides = DB::fetch_all("SELECT * FROM %t WHERE fid=%d ORDER BY `dateline` DESC LIMIT 0, 6",array('forum_thread',$_G['fid']));}-->
<ul class="cl">
<!--{loop $slides $slide}-->
<li><span>•</span><a href="forum.php?mod=viewthread&tid=$slide[tid]" title="$slide[subject]" target="_blank" >$slide[subject]</a></li>
</li>
<!--{/loop}-->
</ul>
作者: bug八阿哥 時間: 2024-11-16 13:13
試試
<!--{eval $slides = DB::fetch_all("SELECT tid, subject, message FROM %t WHERE fid=%d ORDER BY `dateline` DESC LIMIT 0, 6", array('forum_thread', $_G['fid']));}-->
<!--{eval $slides = DB::fetch_all("SELECT t.tid, t.subject, p.message FROM %t t LEFT JOIN %t p ON t.tid = p.tid WHERE t.fid=%d AND p.first=1 ORDER BY t.dateline DESC LIMIT 0, 6", array('forum_thread', 'forum_post', $_G['fid']));}-->