Thread

I wonder if it’s possible to display random 3 members from a certain group along with their avatars, names and some custom field data in a widget on a homepage?

PipSpratt,

You have the Custom Profile Data Tag available to you which will give you one instance of a member profile

I would suggest maybe using the Query Module for this

{exp:query sql="SELECT screen_name, email, location FROM exp_members WHERE group_id = '1' ORDER BY random DESC LIMIT 3"}

{screen_name}
{email}
{location}

{/exp:query}

Does that help?

thank you John, I was thinking about using Query Module but when I put your code on my website (I only changed group_id) all I get is:

  M20o93H7pQ09L8X1t49cHY01Z5j4TT91fGfr

...

PipSpratt,
Try it without the random bit for the moment

{exp:query sql="SELECT screen_name, email, location FROM exp_members WHERE group_id = '1' DESC LIMIT 3"}

again:
  M20o93H7pQ09L8X1t49cHY01Z5j4TT91fGfr

PipSpratt,

Can I confirm that you have the query module installed?

Have you nested this within any other tag say like the Channel Entries tag?

Test this on a blank template with nothing else in there only the code above

Try some of the other examples of the Query Docs page too

yes, you’re correct, I forgot to install Query 😊
But now I’ve installed it and when I want to access my homepage I see blank page. Here’s my code:

all right, it works with

{exp:query sql="SELECT screen_name, email, location FROM exp_members WHERE group_id = '6' ORDER BY RAND() LIMIT 3"}

instead

{exp:query sql="SELECT screen_name, email, location FROM exp_members WHERE group_id = '6' DESC LIMIT 3"}

thanks 😊

Excellent! We got there in the end 😊 Feel free to start a new thread if you have any more questions