列表页如何获得数据总数？

[Keshena]

试下这个
<?php
$w_total=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_表名 where classid=$navclassid and checked");
$total=$w_total[total];
?><span class="num">共有<?=$total?>条</span>

如是v7.2:
<?php
$w_total=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_表名 where classid=$navclassid");
$total=$w_total[total];
?><span class="num">共有<?=$total?>条</span>

如查v7.2新闻列表文章数：
<?php
$w_total=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_news where classid=$navclassid");
$total=$w_total[total];
?><span class="num">共有<?=$total?>条</span>