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

本文实例报告了帝国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