代码如下:
最新会员SQL:
1 | 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 |
按积分排行SQL:
1 | 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查询调用看这个说明:http://www.phome.net/doc/ecmsedu/base/mbzz/html/other.html#q1
标签 帝国cms使用教程网站会员帝国CMS调用方法