Question:
I’m trying to create a customized member list page by making use of the existing member information in the control panel.
Is there a tag I can use to list all the members, and only certain fields?
Answer:
You can do this by using the query module and this code:
select exp_members.member_id, exp_members.username, exp_members.screen_name,
exp_member_data.m_field_id_2 as city
from exp_members, exp_member_data
where exp_members.member_id = exp_member_data.member_id
and exp_member_data.m_field_id_2 > '' order by exp_members.member_id asc
If you get an error message after upgrading your version of EE, it is caused by the use of double quotes inside the query string. Fixed in example above.
Category:Members Category:Templates Category:Queries