帝国cms灵动标签自动获取分表ID

帝国CMS灵动标签自动获取分表ID

<?php
$ecms_bq_sql=sys_ReturnEcmsLoopBq(栏目ID/专题ID,显示条数,操作类型,只显示有标题图片,附加SQL条件,显示排序);
$bqno=0;
while($bqr=$empire->fetch($ecms_bq_sql))
{
        $bqsr=sys_ReturnEcmsLoopStext($bqr);
        $bqno++;
        //
    $mid=(int)$class_r[$classid]['modid'];
        $tbname=$emod_r[$mid]['tbname'];
        $nr=$empire->fetch1("select * from {$dbtbpre}ecms_{$tbname}_data{$r[stb]} where id='$r[id]' and classid='$r[classid]' limit 1 ");
        ?>
         
        <?=$nr[newstext]?>

        <?php
}
?>

[e:loop={"select * from [!db.pre!]ecms_news limit 10000",10000,24,0,'',''}]
<?php
$fb=$empire->fetch1("select * from {$dbtbpre}ecms_news_data_{$bqr[stb]} where id='$bqr[id]'");
?>
主表标题:<?=$bqr[title]?>
副表内容:<?=$fb[newstext]?>
[/e:loop]