如何调用同一个会员在不同栏目发布的信息数量
网站首页调用会员信息使用灵动标签调用的，还想实现同一会员在栏目A发布10篇；栏目B发布20篇；栏目c发布30篇；
| <?php $t=$dbtbpre."ecms_news"; $userid=$bqr[userid]; echo $num=$empire->gettotal("select count(*) as total from $t where userid=1 and ismember=1 and classid=78"); ?> |
[e:loop={"select userid as userid,company as title,address as address,saytext as saytext,userpic as titlepic from [!db.pre!]enewsmemberadd where company<>'' order by userid desc limit 8",10,24,0}] <li> <div class="box"> <p class="face"><a href="/e/space/?userid=<?=$bqr[userid]?>" target="_blank"><img src="<?=$bqr[titlepic]?>" class="pic" alt="<?=$bqr[title]?>" /><b class="ico-sucrate"></b></a></p> <div class="block"> <p class="name"><?=$bqr[title]?></p> <p class="mark"><em class="g_mr10"><?=esub($bqr[saytext],42)?></em> </p> <p class="main"><span class="fee"><em class="tag h">已认证</em></span> </p> </div> <p class="good"><em>产品： <?php $t=$dbtbpre."ecms_news"; $userid=1; echo $num=$empire->gettotal("select count(*) as total from $t where userid=1 and ismember=1 and classid=1"); ?> 个</em><em>方案：10个</em><em>资讯：10篇</em></p> </div></li> [/e:loop] |