循環調用最新帖子，能加上帖子的簡介嗎？

duoduobaba

<!--{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>&#8226;</span><a href="forum.php?mod=viewthread&tid=$slide[tid]" title="$slide[subject]" target="_blank" >$slide[subject]</a></li>
</li>
<!--{/loop}-->
        </ul>

1 貢獻

最佳答案

試試

1. <!--{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']));}-->
   
2. <ul class="cl">
   
3. <!--{loop $slides $slide}-->
   
4. <li>
   
5.     <span>&#8226;</span>
   
6.     <a href="forum.php?mod=viewthread&tid=$slide[tid]" title="$slide[subject]" target="_blank">$slide[subject]</a>
   
7.     <p>{echo cutstr(strip_tags($slide['message']), 100)}</p>
   
8. </li>
   
9. <!--{/loop}-->
   
10. </ul>

復制代碼

• bug八阿哥
• 發表于2024-11-16 14:49:04
• 詳細答案 >

bug八阿哥

試試

1. <!--{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']));}-->
   
2. <ul class="cl">
   
3. <!--{loop $slides $slide}-->
   
4. <li>
   
5.     <span>&#8226;</span>
   
6.     <a href="forum.php?mod=viewthread&tid=$slide[tid]" title="$slide[subject]" target="_blank">$slide[subject]</a>
   
7.     <p>$slide[message]</p> <!-- 添加帖子簡介 -->
   
8. </li>
   
9. <!--{/loop}-->
   
10. </ul>

復制代碼

duoduobaba

bug八阿哥 發表于 2024-11-16 13:13
試試

(1054) Unknown column 'message' in 'field list'

bug八阿哥

試試

1. <!--{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']));}-->
   
2. <ul class="cl">
   
3. <!--{loop $slides $slide}-->
   
4. <li>
   
5.     <span>&#8226;</span>
   
6.     <a href="forum.php?mod=viewthread&tid=$slide[tid]" title="$slide[subject]" target="_blank">$slide[subject]</a>
   
7.     <p>{echo cutstr(strip_tags($slide['message']), 100)}</p>
   
8. </li>
   
9. <!--{/loop}-->
   
10. </ul>

復制代碼