久久久久av_欧美日韩一区二区在线_国产精品三区四区_日韩中字在线

Discuz! 官方交流社區

標題: 循環調用最新帖子，能加上帖子的簡介嗎？ [打印本頁]
作者: 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>&#8226;</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
試試
  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    時間: 2024-11-16 14:42
bug八阿哥 發表于 2024-11-16 13:13
試試

(1054) Unknown column 'message' in 'field list'
作者: bug八阿哥    時間: 2024-11-16 14:49
試試
  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>
復制代碼




歡迎光臨 Discuz! 官方交流社區 (http://www.9999xn.com/) Powered by Discuz! W1.0