调用会员在某个数据表发帖量的排行,没有发布信息的会员按照会员ID排序sql:select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group
修改e/enews/plfun.php文件,找到:设置最后发表时间在下面加上这个$usql=$empirequery(update {$dbtbpre}ecms_.$clas_r[$clasid][tbname]. set havehtml=0 where id=$id);然后发表评论的地址返回地址改下就成input type
调用会员在某个数据表发帖量的排行,没有发布信息的会员按照会员ID排序代码如下:select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember
代码如下:[e:loop={select * from ( select id,clasid,titleurl,filename,title,newstime,titlepic from phome_ecms_book where newstime union select id,clasid,titleurl,filename,title,newstime,titlepic from ph
SQL 如何调用 所有软件下载的次数 下面就是调用方法了软件总下载数: gettotal("select sum(totaldown) as total from phome_ecms_download")次文章总浏览数:gettotal("select sum(onclick) as total from phome_ecms_n
在任何模板里面均可添加以下代码$quyu=$empirefetch1("select * from phome_enewsf where f='quyu' and tid='9'");$quyu=explode("|",$quyu[fvalue]);for ($i=0;$icount($quyu);$i++){echo 'option value="'.$quyu[$