1、求助？帝国cms主、副表、用户表2个、共4个表同时调用方法
这个cms之前接触过感觉太复杂了，感觉还是pageadmin cms容易上手。
2、帝国CMS如何实现多表信息调用
这里是模板样式[/e:loop]最新调用：[e:loop={'select title,titleurl,titlepic from [!db.pre!]ecms_photoz where classid in(46,47,51) Union All select title,titleurl,titlepic from [!db.pre!]ecms_downloadz ',0,24,0}]这里是模板样式[/e:loop]以上两例是调用图片和下载模型中的。。[!db.pre!]ecms_photoz 图片数据表（注：系统默认是[!db.pre!]ecms_photo）[!db.pre!]ecms_downloadz下载数据表（注：系统默认是[!db.pre!]ecms_download）参数classid in(46,47,51) 这里是调用的栏目多个用,分开and isgood=1 条件其他参数和灵动标签一样最新5条记录[e:loop={'select title,titleurl,jiage from [!db.pre!]ecms_a where classid in(7) and jiage>=100 and jiage=100 and jiage
3、帝国cms首页多表调用,要调用栏目缩略图+标题。
本来不想回答 去年做过项目4表联合 拿去自己改吧 不会改就没办法 不解释
[e:loop={'select *
from
(
(select id,classid,istop,title,titleurl,titlepic,newstime from phome_ecms_news where istop=1 order by newstime desc limit 13 )
Union All
(select id,classid,istop,title,titleurl,titlepic,newstime from phome_ecms_news1 where istop=1 order by newstime desc limit 13)
Union All
(select id,classid,istop,title,titleurl,titlepic,newstime from phome_ecms_news2 where istop=1 order by newstime desc limit 13)
Union All
(select id,classid,istop,title,titleurl,titlepic,newstime from phome_ecms_news3 where istop=1 order by newstime desc limit 13)
) as A order by newstime desc limit 20',0,24,0}]
<?php
$fb=$empire->fetch1("select *
from
(
(select id,classid,smalltext from phome_ecms_news_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
Union All
(select id,classid,smalltext from phome_ecms_news1_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
Union All
(select id,classid,smalltext from phome_ecms_news2_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
Union All
(select id,classid,smalltext from phome_ecms_news3_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
) as A");
?>
<li class="clearfix">
<a target='_blank' href="<?=$bqr[titleurl]?>" title="<?=$bqr[title]?>" class="index-img"><img src="<?=$bqr[titlepic]?$bqr[titlepic]:'404.jpg'?>" alt="<?=$bqr[title]?>"></a>
<div class="index-text">
<h1><a target='_blank' href="<?=$bqr[titleurl]?>"><?=$bqr[title]?></a>
</h1>
<div class="index-con"></div>
<div class="index-intro"><a target="_blank" href="<?=$bqr[titleurl]?>?from=index_new_intro"><?=$fb[smalltext]?></a></div>
<div class="index-like clearfix">
<span class="time">
<?php
$fr=$empire->fetch1("select *
from
(
(select id,classid,infotags from phome_ecms_news_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
Union All
(select id,classid,infotags from phome_ecms_news1_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
Union All
(select id,classid,infotags from phome_ecms_news2_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
Union All
(select id,classid,infotags from phome_ecms_news3_data_1 where id='$bqr[id]' and classid='$bqr[classid]')
) as A");
$keyr=explode(',',$fr[infotags]);
for($i=0;$i<2;$i++)
{
echo'<span><a href="/liaotian/tags-'.$keyr[$i].'-0.html" target=_blank>'.$keyr[$i].'</a></span> ';
}
?>
</span>
<span class="time"><?=format_datetime($bqr[newstime],"m-d")?></span>
<div class="post-ope">
<a href="/e/public/digg/?classid=<?=$bqr[classid]?>&id=<?=$bqr[id]?>&dotop=1&ajaxarea=diggnum<?=$bqr[id]?>" class="post-like-btn post-like" id="post-like-top-btn">
<script>
document.write('<script src="/e/public/ViewClick/?classid=<?=$bqr[classid]?>&id=<?=$bqr[id]?>&down=5?t='+Math.random()+'"><'+'/script>');
</script>
</a>
</div>
</div>
</div>
</li>
[/e:loop]
功能：联合取4表数据 关联取附表简介 并取标签 附加顶功能 动态浏览量等
4、请问帝国CMS栏目表格显示怎么做啊？
你的意思是：
做了一个数据模型（该数据模型简称为：A数据模型）
然后建立一个栏目（该栏目简述为：B栏目）使用A数据模型
然后在B栏目中存储上述你的图片所展示的信息
是这个意思吗？
如果是这个意思的话，请在A数据模型中定义：
证书编号字段field1
姓名字段field2
性别字段field3
批准日期字段field4
考级单位字段field5
证书字段field6
然后，在定义这个模型中的上述6个字段可以在列表页展示
然后自己在列表页模版中写相应的模版，如：
<table>
<tr>
<th>证件编号</th>
<th>姓名</th>
<th>性别</th>
<th>批准日期</th>
<th>考级单位</th>
<th>证书</th>
<th>查看</th>
</tr>
[!--empirenews.listtemp--]<!--list.var1-->[!--empirenews.listtemp--]
</table>
然后在list.var中写入如下模版信息：
<tr>
<td>[!--field1--]</td>
<td>[!--field2--]</td>
<td>[!--field3--]</td>
<td>[!--field4--]</td>
<td>[!--field5--]</td>
<td>[!--field6--]</td>
<td><a href="[!--titleurl--]">查看</a></td>
</tr>