Dede member list calls methods applicable to enterprises and individuals
Editor to share with you the list of dede members to call suitable for enterprises, personal methods, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!
How to call dede membership list for enterprises and individuals?
The list of dede members is sorted by registration time, which is suitable for enterprises and individuals. The relevant codes are sorted out as follows. Don't miss the friends you need.
Call 12 enterprise members to sort by registration time
The code is as follows:
{dede:sql sql='select * from dede_member where mtype= "Enterprise" order by mid limit 0J 12'} [field:uname/] {/ dede:sql}
Call 12 individual members to sort by registration time
The code is as follows:
{dede:sql sql='select * from dede_member where mtype= "personal" order by mid limit 0J 12'} [field:uname/] {/ dede:sql}
Detailed explanation
Use the sql tag of dede
Sql statement
The code is as follows:
Select * from dede_member where mtype= "personal" order by mid limit 0Magol 12 mtype= "individual" to determine whether it is a personal type order by mid is arranged by mid (registered ID number) limit 0Magne12 starts with Article 0 data and reads 12 items and returns.
Related call
Transfer 12 of all members
The code is as follows:
{dede:sql sql='select * from dede_member order by mid limit 0JI 12'} [field:uname/] {/ dede:sql}
12 of all members are sorted by the last login time.
The code is as follows:
{dede:sql sql='select * from dede_member order by logintime limit 0JI 12'} [field:uname/] {/ dede:sql}
12 members who have uploaded avatars are sorted by the last login time and their avatars are displayed.
The code is as follows:
{dede:sql sql='select * from dede_member where length (face) > 0 order by logintime limit 0J 12'}
{/ dede:sql} above is all the contents of the dede member list calling methods applicable to enterprises and individuals. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
