SELECT A.*,A.aid AS id FROM qb_article A  WHERE A.yz=1  AND  A.fid in(3) AND A. keywords LIKE '%刘德华演唱会%'  ORDER BY A.list DESC LIMIT 5


模板形如
<A HREF="bencandy.php?fid={$fid}&id={$aid}" target='_blank' style="$fontcolor;$fontweight">$title</a><br>

 

 

fid in(这里是你的栏目id)如果有多个就写多个栏目，中间用,分割。


更简单的代码是

SELECT *  FROM qb_article   WHERE yz=1  AND  fid in(3) AND keywords LIKE '%刘德华演唱会%'  ORDER BY list DESC LIMIT 5