让php脚本多次运行

Question

I have a system where a PHP script uses MySQL to get info based on a user. Then, based on that information, a certain button will be displayed. The database that is being called has columns:

id
user_one
user_two

This is meant to check if two users are friends. However, my problem is that if a user has more that 1 friend the script only works for the 1st friend.

$select_friends_query = mysql_query("SELECT friend_id FROM friends WHERE user_id = '$user'");
 while($friend_row = mysql_fetch_assoc($select_friends_query)) {
$friend = $friend_row['friend_id'];
}

if ($username == $friend) {
 $addAsFriend = '<input type="submit" class = "frnd_req" name="removefriend" value="Disassociate">';
}

else
{
 $addAsFriend = '<input type = "submit" class = "frnd_req" name = "addfriend" value = "Send Associate Request">';
 }
}
}

Then I have echo $addAsFriend later.

Answer 1

You have to look over all results. Like the while loop example in http://www.php.net/manual/en/function.mysql-fetch-assoc.php