帝国cms调用某个数据表中会员的发帖排行榜教程
调用会员在某个数据表发帖量的排行，没有发布信息的会员按照会员ID排序sql：select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group……
调用会员在某个数据表发帖量的排行，没有发布信息的会员按照会员ID排序
sql：
select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group by u.userid order by myorder desc,u.userid asc效果图：
- 上一篇
帝国cms教程只调用在当前表中发过信息的会员排行
select userid,count(*)as myorder from phome_ecms_photo group by userid order by myorder desc
- 下一篇
帝国cms模板教程提交评论后自动重新生成内容页
修改e/enews/plfun.php文件，找到：//设置最后发表时间在下面加上这个$usql=$empire->query("update {$dbtbpre}ecms_".$class_r[$classid][tbname]." set havehtml=0 where id='$id'");然后发表评论的地址返回地址改下就