akirnarwiggerv
New Member
How can I join \[code\]users\[/code\] with \[code\]users_friends.user_id\[/code\] when \[code\]user_id = '" . $user_id . "'\[/code\]And join \[code\]users\[/code\] with \[code\]users_friends.friend_id\[/code\] when \[code\]friend_id = '" . $user_id . "'\[/code\]if \[code\]user_id = '" . $user_id . "'\[/code\]\[code\]INNER JOIN users ON users_friends.user_id = users.user_id\[/code\]if \[code\]friend_id = '" . $user_id . "'\[/code\]\[code\]INNER JOIN users ON users_friends.friend_id = users.user_id\[/code\]Current MySQL Code.\[code\]SELECT COUNT(user_id) as friendsFROM users_friendsWHERE (user_id = '" . $user_id . "' OR friend_id = '" . $user_id . "')AND friendship_status = '1'\[/code\]