1、共有文章:** 篇{dede:sql sql=select count(*) as c from dede_archives where channel=1}共有文章:[field:c /]篇{/dede:sql}2、共有图集:** 个{dede:sql sql=select count(*) as c from dede_archives where channel=2}共有图集:[fiel...
/member/inc/config_space.php 最后 加入以下函数 function count_arc(){ global $dsql,$uid; $sql = SELECT mid,userid FROM `dede_member` WHERE `userid` = .$uid.; $row = $dsql-GetOne($sql); $count = $dsql-GetOne(select COUNT(*) AS dd FROM dede_arch...
织梦dedecms各种数字统计SQL语句 。 共有评论:多少条 {dede:sql sql=select count(ID) as c from dede_feedback}共有评论:[field:c /]条{/dede:sql} 共有会员:多少名 {dede:sql sql=select count(ID) as c from dede_member }共有会...
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) 1) 2、删除表中多余的重复记录,重...
修改全部在/include/taglib/memberlist.lib.php 这个文件中: 找到: 1 $sql = SELECT mb.*,ms.spacename,ms.sign FROM `dede_member` mb 2 LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid 3 $wheresql order by mb.{$orderby} DESC LIMIT 0,$row...