Mohammedmehdi

Hello 2 tables - users (userid, username) - friends (friendshipid, user1, user2, accepted) I have a friends search box (works like google's/facebook's auto suggest). This search box is meant to be used to pick a friend to send a private message to. So far, all my code can do is autosuggest people on the social network (basically display all people on the users table based on the characters typed). <?php mysql_connect("localhost","username","pass"); mysql_select_db("dbname"); $term=$_GET["term"]; $query=mysql_query("SELECT userid, username FROM users where username like '%".$term."%'"); $json=array(); while($friend=mysql_fetch_array($query)){ $json[]=array( 'value'=> $friend["username"] ); } echo json_encode($json); ?> I wanted it to filter out those who are not friends. BTW, just to clarify, the logged in user who wants to send a private message, his userid could be on either user1/user2 of the friends table. Any idea behind the logic that could sort this issue? Will really appreciate any help