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>