I have a community site (written in PHP) in which I would like to display the profile picture and username of MULTIPLE yet RANDOM members.
I have successfully been able to call up the random profile picture and username of a member using the following SQL query syntax: mysql_query('SELECT * FROM members ORDER BY RAND() LIMIT 1')
But, as someone with more SQL experiance that I can see, this code only allows for one record to be randomly pulled and displayed from the data table 'members'.
I want to randomly pull two or three or even more records radomly. I just can't figure out the SQL syntax.
Can someone help me out? I think that what I am asking to do can be accomplished via the SQL syntax issue but, if you have a better way to skin this cat, I am all ears.
I love this site and thank you so much for just being here! You guys are great!