Update statement wont work mysql
<p>I have an unfriend system which sort of works. When the unfriend button is clicked, the table is updated to remove the friend you have updated. The only problem being that it deletes all your friends instead of just 1 in an array. </p>

<p>The array is similar to this friend1,friend2,friend3 and if u wish to delete friend2, friend1 and 3 will also be deleted for no reason. </p>

<p>Help :(</p>

<pre><code>    if (@$_POST['removefriend']) {
    //Friend array for logged in user
     $add_friend_check = mysql_query("SELECT friend_array FROM users WHERE username='{$_SESSION['user_login']}'");
     $get_friend_row = mysql_fetch_assoc($add_friend_check);
      $friend_array = $get_friend_row['friend_array'];
      $friend_array_explode = explode(",",$friend_array);
      $friend_array_count = count($friend_array_explode);

      //Friend array for user who owns profile
      $add_friend_check_username = mysql_query("SELECT friend_array FROM users WHERE username='{$_SESSION['user_login']}'");
      $get_friend_row_username = mysql_fetch_assoc($add_friend_check_username);
        $friend_array_username = $get_friend_row_username['friend_array'];
        $friend_array_explode_username = explode(",",$friend_array_username);
        $friend_array_count_username = count($friend_array_explode_username);

        $usernameComma = ",".$username;
        $usernameComma2 = $username.",";

        $userComma = ",".$user;
        $userComma2 = $user.",";

        if (strstr($friend_array,$usernameComma)) {
        $friend1 = str_replace("$usernameComma","",$friend_array);
        }
        else
        if (strstr($friend_array,$usernameComma2)) {
        $friend1 = str_replace("$usernameComma2","",$friend_array);
         }
         else
         if (strstr($friend_array,$username)) {
          $friend1 = str_replace("$username","",$friend_array);
          }
         //Remove logged in user from other persons array
         if (strstr($friend_array,$userComma)) {
         $friend2 = str_replace("$userComma","",$friend_array);
           }
         else
         if (strstr($friend_array,$userComma2)) {
         $friend2 = str_replace("$userComma2","",$friend_array);
         }
         else
         if (strstr($friend_array,$user)) {
         $friend2 = str_replace("$user","",$friend_array);
         }

         $friend2 = "";

        $removeFriendQuery = mysql_query("UPDATE users SET friend_array='$friend1' WHERE username='{$_SESSION['user_login']}'");
        $removeFriendQuery_username = mysql_query("UPDATE users SET friend_array='$friend2' WHERE username='{$_SESSION['user_login']}'");
        echo "Friend Removed ...";
        }
</code></pre>
