旗下导航:搜·么
当前位置:网站首页 > CMS教程 > 正文

分享帝国CMS首页挪用最新会员、活泼会员与积分排行的要领【CMS教程】,帝国cms

作者:搜教程发布时间:2019-11-29分类:CMS教程浏览:80评论:0


导读:本文实例报告了帝国CMS首页挪用最新会员、活泼会员与积分排行的要领。分享给人人供人人参考。细致完成要领以下:SQL代码以下,最新会员SQL:代码以下:select...

本文实例报告了帝国CMS首页挪用最新会员、活泼会员与积分排行的要领。分享给人人供人人参考。细致完成要领以下:

SQL代码以下,最新会员SQL:

代码以下:

select a.userid,a.username,b.userpic as titlepic from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as 
b ON a.userid=b.userid order by a.userid desc limit 10

引荐进修《帝国cms教程》

按积分排行SQL:

代码以下:

select a.userid,a.username,b.userpic as titlepic from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as
 b ON a.userid=b.userid order by a.userfen desc limit 10

标签模板顶用[!--userpic--]示意头像,[!--userid--]示意用户id,[!--username--]示意用户名.

以全能标签为例,其按积分排行SQL挪用语句以下:

[ecmsinfo]"select a.userid,a.username,b.userpic as titlepic from phome_enewsmember as a LEFT JOIN 
phome_enewsmemberadd as b ON a.userid=b.userid order by a.userfen desc limit 10",10,30,0,24,1,0[/ecmsinfo]

愿望本文所述对人人的帝国CMS建站有所协助。

以上就是分享帝国CMS首页挪用最新会员、活泼会员与积分排行的要领的细致内容,更多请关注ki4网别的相干文章!

标签:帝国cms


欢迎 发表评论: