Question:
Is there a plugin that would allow me to feature a random username, picture and small snippet of information could be placed on a main page everytime it was viewed?
Answer:
{exp:query sql="SELECT screen_name AS user_screen_name, photo_filename, bio FROM exp_members ORDER BY rand() LIMIT 1"}
<p>Name: {screen_name}</p>
<p>Photo: /images/member_photos/{photo_filename}</p>
<p>Bio: {bio}</p>
{/exp:query}
Category:Queries Category:Templates Category:Members