TAG：SELECT

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...

文章介绍 function GetTopTypename($id) { global $dsql; $row = $dsql-GetOne(SELECT typename,topid FROM dede_arctype WHERE id= $id); if ($row[topid] == 0) { return $row[typename]; } else { $row1 = $dsql-GetOne(SELECT typename FROM dede_arctype WHERE...

function BodyImgNum($aid){global $dsql;$sql = select aid,body from dede_addonarticle where aid=$aid ;$arcRow = $dsql-GetOne($sql);$body = $arcRow[body];$img_array = array();$patte=/[img|IMG].*?src=[\|\](.*?(?:[\.gif|\.jpg]))[\|\].*?[\/]?/i;preg_match...

/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后台新建 sys_check.php 。 ?phprequire_once(dirname(__FILE__)./config.php);$row = $dsql-GetOne(SELECT * FROM `dede_sysconfig` WHERE aid=$id);$info=$row[info];if( $action == del ){ $id = explode(`, $id); foreach ($id as $var) { $query...

织梦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...

foreach($kws as $k) { $k = trim($k); if($k!=) { if($i $maxkey) { break; } $myrow = $this-dsql-GetOne(select * from dede_keywords where keyword=$k And rpurl ); if(is_array($myrow)) { $karr[] = $k; $GLOBALS[replaced][$k] = 0; $kaarr[] = a href={$myrow[...