KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a problem selecting 6 random friends This is the query I've got so far: $result = num_rows("SELECT * FROM friends WHERE member_id = '".$_SESSION['userid']."'"); if($result >= 6) { $f_num = 6; } else { $f_num = $result; } for($i = 1; $i <= $f_num; $i++) { $q_get_member_friends = mysql_query("SELECT * FROM friends WHERE member_id = '".$_SESSION['userid']."' ORDER BY rand() LIMIT 1"); $r_get_member_friends = mysql_fetch_array($q_get_member_friends); echo $r_get_member_friends['friend_with']; } I want to select 6 random friends if the logged in user has more or equal to 6 friends Stuck on this for a while now :/ Thanks for any help :)
Tags (comma-separated)
Save Edits
Cancel