List all authors from a specific channel
How Do I?
Hi,
I would like to be able to list all the authors with their member ID (members) from a specific channel. I have not been able to find a solution yet. I did have a look at an old post but couldn’t figure out how to add the member ID.
Hopefully some smart people on this forum could help me.
I would simply use an SQL query, like this:
{exp:query sql="
SELECT DISTINCT screen_name, member_id
FROM exp_channel_titles AS t
INNER JOIN exp_members AS m ON t.author_id = m.member_id
WHERE channel_id = '9'
"}
{/exp:query}You’ll have to adjust your channel_id, of course.
Thanks Ingmar, Works perfectly. How do I sort by screen_name?
One more line, like so:
{exp:query sql="
SELECT DISTINCT screen_name, member_id
FROM exp_channel_titles AS t
INNER JOIN exp_members AS m ON t.author_id = m.member_id
WHERE channel_id = '9'
ORDER BY screen_name ASC
"}
{/exp:query}Thanks a lot Ingmar.
One more thing, using this exp:query Using this exp:query on an entry page (article), the list only display a list of the same author of the article. Is there a way to turn off the dynamic?
There should be nothing dynamic about this query. Try this:
<ul>
{exp:query sql="
SELECT DISTINCT screen_name AS my_name, member_id AS my_id
FROM exp_channel_titles AS t
INNER JOIN exp_members AS m ON t.author_id = m.member_id
WHERE channel_id = '9'
ORDER BY screen_name ASC
"}
<li>{my_name} ({my_id})</li>
{/exp:query}
</ul>Alternatively you could probably put that piece of code in a snippet or subtemplate and just embed it.
Yes, that solved it, I guess it just crashed with EE screen_name
Thanks again!