TIBALIEDABINO
New Member
How can I grab the count value from the query MySQL query below using PHP.Here is My MySQL code.\[code\]$dbc = mysqli_query($mysqli,"SELECT COUNT(*) FROM((SELECT users_friends.id FROM users_friends INNER JOIN users ON users_friends.user_id = users.user_id WHERE users_friends.user_id = 1 AND users_friends.friendship_status = '1') UNION (SELECT users_friends.id FROM users_friends INNER JOIN users ON users_friends.friend_id = users.user_id WHERE users_friends.friend_id = 1 AND users_friends.friendship_status = '1')) as friends");\[/code\]