php - How to select users friends post and users post -
i need way mysql select * photos username equal "user" or "users friends".
mysql_query("select * photos username='king' or username='$user' or username='wale' or username='prince' order id desc");
above, played around see work , seems work when add specific usernames. however, program automatically select friends.
this original code. need way sql select * photos username equal user or "users friends".
$friendsarray = ""; $countfriends = ""; $friendsarray12 = ""; $addasfriend = ""; $selectfriendsquery = mysql_query("select friend_array users username='$user'"); $friendrow = mysql_fetch_assoc($selectfriendsquery); $friendarray = $friendrow['friend_array']; $friendarray = explode(",",$friendarray); $countfriends = count($friendarray); $friendarray12 = array_slice($friendarray, 0, 12); `
this selects friends array within database. in data base friends located under column called friend_array. separated comma. example ('king,wale,prince'
)
if ($countfriends = $countfriends) { foreach ($friendarray12 $key => $value) { $i++; $getfriendquery = mysql_query("select * users username='$value' limit 1"); $getfriendrow = mysql_fetch_assoc($getfriendquery); $friendusername = $getfriendrow['username']; $friendprofilepic = $getfriendrow['profile_pic']; ` //$friendusername each friend of user. (king prince wale)
$get_photos = mysql_query("select * photos username='$user' or username='$friends' order id desc"); $numrows = mysql_num_rows($get_photos); while($row = mysql_fetch_assoc($get_photos)) { $id = $row['id']; $uid = $row['uid']; $username = $row['username']; $date_posted = $row['date_posted']; $description = $row['description']; $image_url = $row['image_url'];
this gets users post , want select users friends post.
echo " <br> <div class='albums'> <div class='pic5656'> <img src='$pro_pic2' height='30' width='30'> </div> <div class='name45'>$username $id</div> <div class='day56'>$date_posted</div> <img src='$image_url' height='470' width='510'><br><br> $description <div style='float:left;'> $button $countt </div> <a href='javascript:;' onclick='javascript:toggle$id()'><div style='float: right; display: inline;'><img src='./img/more.png'></div></a> <div id='togglecomment$id' style='display:none;' > <iframe src='./comment_frame.php?id=$id' style='height: 70px; width: 100%; min-height: 10px; '></iframe> </div> </div> ";
finally each post displayed.
i need way sql select * photos username equal user or "users friends".
mysql's find_in_set
can save lot of code here:
select * photos username = '$user' or exists (select * form users username = '$user' , find_in_set (photos.username, friend_array) > 0)
Comments
Post a Comment