Friends count of my friends

[eluser]rwestergren[/eluser]
Something like this should get you the number of friends:

Code:

function get_connected_friends($user_id)
{
    $query = $this->db->query("
    SELECT COUNT(*) as friend_count
    FROM friends f
    INNER JOIN users u on(u.id = f.friend_id)
    WHERE f.user_id = $user_id AND f.approved = 1
    ");
    return $query;
}