Friends count of my friends

[eluser]rwestergren[/eluser]
Ahh, I see the error. This should do it:

Code:

function get_connected_friends($user_id)
{
    $query = $this->db->query("
    SELECT u.*,
            (SELECT COUNT(*) as friend_count
            FROM friends f2
            WHERE f2.user_id = u.id AND f2.approved = 1) AS f_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;
}