篩選里面調(diào)用其他頻道數(shù)據(jù)
{eyou:php}
$sql = "ｓｅｌｅｃｔ a.title,a.aid,b.tuanjianleixing FROM ey_archives as a,ey_fangan_content as b where a.aid=b.aid and is_recom=1 order by id desc limit 6";
$tmp_list = db()->query($sql);
foreach ($tmp_list as $_k => $_v) {
echo "欄目ID：".$_v['tuanjianleixing'];
echo " -- ";
echo "文章標(biāo)題：".$_v['title'];
echo " -- ";
echo "文章/index.php?m=home&c=View&a=index&aid=".$_v['aid'];
echo "<br/>";
}
{/eyou:php}