帝國cms調用某一個表的熱門頂的文章和文章里面的圖片數量的方法

<?php
$sql=$empire->query("select * from phome_ecms_news where titlepic <>'' order by diggtop DESC limit 40");
while($r=$empire->fetch($sql))
{
$titleurl=sys_ReturnBqTitleLink($r);//鏈接
$fr=$empire->fetch1("select newstext from {$dbtbpre}ecms_news_data_{$r[stb]} where id='$r[id]'");
$neirong=$fr['newstext'];
$imgcount=substr_count($neirong,"<img");
?>
        <li><a href="<?=$titleurl?>"><img data-original="<?=sys_ResizeImg($r[titlepic],240,180,1)?>" class="thumb"/>
          <h2><?=$r[title]?></h2>
          </a><a href="JavaScript:makeRequest('<?=$public_r[newsurl]?>e/public/digg?classid=<?=$r[classid]?>&id=<?=$r[id]?>&dotop=1&doajax=1&ajaxarea=diggnum<?=$r[id]?>','EchoReturnedText','GET','');" class="like">贊 (<span id="diggnum<?=$r[id]?>"><script src="<?=$public_r[newsurl]?>e/public/ViewClick?classid=<?=$r[classid]?>&id=<?=$r[id]?>&down=5"></script></span>)</a><span class="img-count"><?=$imgcount?></span></li>
<?php
}
?>