百度了一段代碼，不能用，幫忙看一下哪里錯(cuò)了

duoduobaba

DISCUZ調(diào)用論壇帖子當(dāng)前版塊的帖子列表


<!--{eval $slides = DB::fetch_all("SELECT * FROM ".DB::table('forum_thread')." WHERE tid=".$slide[tid]." ORDER BY `dateline` DESC LIMIT 0, 6");}-->
<ul>
<!--{loop $slides $slide}-->
<li>
<a href="forum.php?mod=viewthread&tid=$slide[tid]" title="$slide[subject]" target="_blank" >
<p><img src="uc_server/avatar.php?uid=$slide['authorid']&size=small"></p>
<p>$slide[subject]</p>
<p>日期<!--{echo date("m-d",$slide[dateline])}--> 瀏覽( $slide[views] ) 評(píng)論( $slide[replies] ）</p>
</a>
</li>
<!--{/loop}-->
</ul>

1 貢獻(xiàn)

最佳答案

當(dāng)前板塊應(yīng)該用fid做為條件語(yǔ)句，另外多出不符合X3.5標(biāo)準(zhǔn)

1. <!--{eval $slides = DB::fetch_all("SELECT * FROM %t WHERE fid=%d ORDER BY `dateline` DESC LIMIT 0, 6",array('forum_thread',$_G['fid']));}-->
   
2. <ul>
   
3.     <!--{loop $slides $slide}-->
   
4.     <li>
   
5.         <a href="forum.php?mod=viewthread&tid={$slide['tid']}" title="{$slide['subject']}" target="_blank" >
   
6.             <p><!--{avatar($slide['authorid'],'small')}--></p>
   
7.             <p><!--{$slide['subject']}--></p>
   
8.             <p>日期<!--{echo date("m-d",$slide['dateline'])}--> 瀏覽( {$slide['views']} ) 評(píng)論( {$slide['replies']} ）</p>
   
9.         </a>
   
10.     </li>
    
11.     <!--{/loop}-->
    
12. </ul>

復(fù)制代碼

• 科站網(wǎng)
• 發(fā)表于2024-8-22 11:33:36
• 詳細(xì)答案 >

天外飄仙

WHERE tid=".$slide[tid]."
這個(gè)where條件一看就不對(duì)呢

duoduobaba

天外飄仙 發(fā)表于 2024-8-22 10:56
WHERE tid=".$slide[tid]."
這個(gè)where條件一看就不對(duì)呢

嗯  問(wèn)題就出在這 指定有現(xiàn)成的WHERE tid='1'

科站網(wǎng)

當(dāng)前板塊應(yīng)該用fid做為條件語(yǔ)句，另外多出不符合X3.5標(biāo)準(zhǔn)

1. <!--{eval $slides = DB::fetch_all("SELECT * FROM %t WHERE fid=%d ORDER BY `dateline` DESC LIMIT 0, 6",array('forum_thread',$_G['fid']));}-->
   
2. <ul>
   
3.     <!--{loop $slides $slide}-->
   
4.     <li>
   
5.         <a href="forum.php?mod=viewthread&tid={$slide['tid']}" title="{$slide['subject']}" target="_blank" >
   
6.             <p><!--{avatar($slide['authorid'],'small')}--></p>
   
7.             <p><!--{$slide['subject']}--></p>
   
8.             <p>日期<!--{echo date("m-d",$slide['dateline'])}--> 瀏覽( {$slide['views']} ) 評(píng)論( {$slide['replies']} ）</p>
   
9.         </a>
   
10.     </li>
    
11.     <!--{/loop}-->
    
12. </ul>

復(fù)制代碼