發(fā)布時(shí)間：2019-12-04 來源：未知 瀏覽： 關(guān)鍵詞：帝國(guó)CMS 

本文實(shí)例講述了帝國(guó)CMS首頁(yè)調(diào)用最新會(huì)員、活躍會(huì)員與積分排行的方法。分享給大家供大家參考。具體實(shí)現(xiàn)方法如下：

SQL代碼如下,最新會(huì)員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

推薦學(xué)習(xí)《帝國(guó)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

標(biāo)簽?zāi)０逯杏肹!--userpic--]表示頭像,[!--userid--]表示用戶id,[!--username--]表示用戶名.

以萬能標(biāo)簽為例，其按積分排行SQL調(diào)用語句如下：

[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]

希望本文所述對(duì)大家的帝國(guó)CMS建站有所幫助。

以上就是分享帝國(guó)CMS首頁(yè)調(diào)用最新會(huì)員、活躍會(huì)員與積分排行的方法的詳細(xì)內(nèi)容，更多請(qǐng)關(guān)注魔酷閣其它相關(guān)文章！