范心诺 发表于 2024-11-16 14:47:56

循环调用最新帖子,能加上帖子的简介吗? New




•$slide


      

1 贡献最佳答案

      试试
    •    $slide    {echo cutstr(strip_tags($slide['message']), 100)}       

bug八阿哥发表于29 分钟前
[*]详细答案 >

黎世敏 发表于 2024-11-16 14:48:52

试试
<!--{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']));}--><ul class="cl"><!--{loop $slides $slide}--><li>    <span>•</span>    <a href="forum.php?mod=viewthread&tid=$slide" title="$slide" target="_blank">$slide</a>    <p>$slide</p> <!-- 添加帖子简介 --></li><!--{/loop}--></ul>

郁和静 发表于 2024-11-16 14:48:58

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

成娅旃 发表于 2024-11-16 14:49:20



试试
<!--{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']));}--><ul class="cl"><!--{loop $slides $slide}--><li>    <span>•</span>    <a href="forum.php?mod=viewthread&tid=$slide" title="$slide" target="_blank">$slide</a>    <p>{echo cutstr(strip_tags($slide['message']), 100)}</p> </li><!--{/loop}--></ul>
页: [1]
查看完整版本: 循环调用最新帖子,能加上帖子的简介吗? New