Friends count of my friends

[eluser]JamieBarton[/eluser]
[quote author="rwestergren" date="1343230912"]Ahh, I see. This will give you your friends and the count of how many friends each of them have:

Code:

function get_connected_friends($user_id)
{
    $query = $this->db->query("
    SELECT *,
            (SELECT COUNT(*) as friend_count
            FROM friends f2
            WHERE f2.user_id = f.user_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;
}

[/quote]

That's just giving me the number of friends for me whenever I try to call f_count.