会员个数如何获取去?
准备在网站底部价格会员注册个数,改如何实现呢{loop $tags $k $t}
已注册{$t}个会员
{/loop}
这个好像没有用
count($DT_PRE.'member','1', 60);}-->
已注册:{$mnum}个会员
楼上已答。。。。。。。
www.qliuw.com
会员总数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."member WHERE groupid>4");}
{$t}
求购信息数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."buy WHERE status=3");}
{$t}
供应信息数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."sell WHERE status=3");}
{$t}
企业总数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."company WHERE groupid>5");}
{$t}
  会员总数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."member WHERE groupid>4");}
{$t}    
供应信息数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."sell WHERE status=3");}
{$t}    
求购信息数:
{php $t=$db->get_one("SELECT COUNT(*) AS num FROM ".$DT_PRE."buy WHERE status=3");}
{$t}
谢谢 各位@ 满意结贴
页:
[1]