帝国cms自定义专题列表模板list.var中获取对应专题下的信息、信息数量及信息所属栏目名称

代码如下：

1. $rr = $empire->fetch1("SELECT GROUP_CONCAT(id) from phome_enewsztinfo where ztid='$r[id]'");
2. $ff = $rr[0];
3. $ga = explode(",", $ff);
4. for ($i = 0; $i < 6; $i++) {
5. if ($ga[$i]) {
6. $cc = $empire->fetch1("select * from phome_ecms_app where id='$ga[$i]'");
7.  
8. // 查询phome_enewsclass表
9. $classInfo = $empire->fetch1("select * from phome_enewsclass where classid='$cc[classid]'");
10. $classname = $classInfo['classname'];
11.  
12. $nr .= '<li><a href="'.$cc[titleurl].'" target="_blank"><img src="'.$cc[titlepic].'" alt="'.$cc[title].'" /><p>'.$cc[title].'</p><span>'.$classname.'</span></a></li>';
13. }
14. }
15. $num = $empire->gettotal("select count(*) as total from phome_enewsztinfo where ztid='$r[id]'");
16. $listtemp = '<li>
17. <a href="/[!--titleurl--]/" target="_blank"><img src="[!--titlepic--]" alt="[!--title--]"/></a>
18. <div class="info">
19. <a href="/[!--titleurl--]/" target="_blank"><p class="name">[!--title--]</p><span>更新：[!--newstime--]</span></a>
20. <ul>
21. '.$nr.'
22. </ul>
23. </div>
24. <em><i class="ico"></i><a href="/[!--titleurl--]/" target="_blank">'.$num.'</a>款</em>
25. <div class="line"></div>
26. </li>';