灰儿 发表于 2013-5-6 14:34:57

phpcms v9 统计会员投稿总数

代码:
统计文章总数
{pc:get sql="SELECT count(*) as zs FROM phpcms_news "}
{loop $data $key $r}
{$r}
{/loop}
{/pc}

代码二:
统计某位会员发帖数量
{pc:get sql="SELECT count(*) as userconut FROM phpcms_news where username = '某会员名称' "}
{loop $data $key $r}
{$r}
{/loop}
{/pc}

注:
select count(*)查每个表有多少条记录



页: [1]
查看完整版本: phpcms v9 统计会员投稿总数