帝国cms专题列表根据关键词变量调用文章的方法
帝国cms专题列表根据关键词变量调用文章的两种方法。
方法1:
<?php $ztname = $empire->gettotal("select ztname as total FROM {$dbtbpre}enewszt where ztid='$navclassid'");?>[e:loop={"select * from [!db.pre!]ecms_news where classid=3 and title like '%{$ztname}%' order by onclick desc limit 3",0,24}]<li> <a href="<?=$bqsr['titleurl']?>" class="title"><?=$bqr['title']?></a></li>[/e:loop]
方法2推荐:
[e:loop={"select * from [!db.pre!]ecms_news where classid=3 and title like '%{$class_zr[$navclassid]['ztname']}%' order by onclick desc limit 3",0,24}] <li><a href="<?=$bqsr['titleurl']?>" class="title"><?=$bqr['title']?></a></li>[/e:loop]