List users with certain role in template

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Vladimir Garagulya

    (@shinephp)

    13 years ago

    Later is better than never :). Use the SQL query below to get needed users list:

    select b.user_login
	from wp_usermeta a
	join wp_users b on a.user_id=b.ID
	where a.meta_key='wp_capabilities' and a.meta_value like '%advisors%';

    Thread Starter greencode

    (@greencode)

    13 years ago

    Thanks for this but not sure how I would then list those users in my template?

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘List users with certain role in template’ is closed to new replies.