本帖最后由 zzl1011 于 2009-10-29 17:33 编辑
你看代码
<div class="list">
<h3>理财学习</h3>
<ul>
<!--{block name="uchblog" parameter="sql/SELECT%20count%28subject%29%20as%20count%20FROM%20%60supe_partyitems%60%20where%20catid%3D61/limit/0,1/cachetime/900/cachename/fenleizhuti"}--><!--分类主题-->
<li><a href="$siteurl/m.php?name=$modelsinfoarr[modelname]&mo_catid=61">英语</a>$_SBLOCK['fenleizhuti'][0][count]</li>
<!--{block name="uchblog" parameter="sql/SELECT%20count%28subject%29%20as%20count%20FROM%20%60supe_partyitems%60%20where%20catid%3D62/limit/0,1/cachetime/900/cachename/fenleizhuti"}--><!--分类主题-->
<li><a href="$siteurl/m.php?name=$modelsinfoarr[modelname]&mo_catid=62">讲座</a>$_SBLOCK['fenleizhuti'][0][count]</li>
<!--{block name="uchblog" parameter="sql/SELECT%20count%28subject%29%20as%20count%20FROM%20%60supe_partyitems%60%20where%20catid%3D63/limit/0,1/cachetime/900/cachename/fenleizhuti"}--><!--分类主题-->
<li><a href="$siteurl/m.php?name=$modelsinfoarr[modelname]&mo_catid=63">职业</a>$_SBLOCK['fenleizhuti'][0][count]</li>
<!--{block name="uchblog" parameter="sql/SELECT%20count%28subject%29%20as%20count%20FROM%20%60supe_partyitems%60%20where%20catid%3D64/limit/0,1/cachetime/900/cachename/fenleizhuti"}--><!--分类主题-->
<li><a href="$siteurl/m.php?name=$modelsinfoarr[modelname]&mo_catid=64">理财</a>$_SBLOCK['fenleizhuti'][0][count]</li>
<!--{block name="uchblog" parameter="sql/SELECT%20count%28subject%29%20as%20count%20FROM%20%60supe_partyitems%60%20where%20catid%3D65/limit/0,1/cachetime/900/cachename/fenleizhuti"}--><!--分类主题-->
<li><a href="$siteurl/m.php?name=$modelsinfoarr[modelname]&mo_catid=65">健康</a>$_SBLOCK['fenleizhuti'][0][count]</li>
</ul>
<div class="clear"></div>
这个语句调出的是 “健康0” 里面的 “0” 分类活动数
SELECT count(subject) as count, catid FROM `supe_partyitems` where catid = $catid |