Shulou(Shulou.com)06/02 Report--

This article is about the latest members, active members and points ranking on the home page of Imperial CMS. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

This paper gives an example of the method of calling the latest members, active members and points ranking on the home page of Imperial CMS. Share it with you for your reference. The specific implementation methods are as follows:

The SQL code is as follows. The newest member SQL:

The code is as follows:

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

Rank SQL by points:

The code is as follows:

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

The tag template uses [!-- userpic--] to represent the avatar, [!-- userid--] to represent the user id, and [!-- username--] to indicate the user name.

Take the universal label as an example. The SQL call statement ranked by integral is as follows:

[ecmsinfo] "select a.username as titlepic from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as b ON a.userid=b.userid order by a.userfen desc limit a. Username.b.userpic 10", 10meme30re0pic 0pic 024reparted1releg0 [/ ecmsinfo] Thank you for your reading! This is the case of calling the latest members, active members and points ranking on the home page of Imperial CMS. I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.