I'm having a minor issue with a tiny mysql query. I'm trying to select a few columns and at the same time count what ever comes out of the table and add the count result as another column. so let's say I have three friends 

* friend 1
* friend 2
* friend 3

I want to see another column says allfriends=>3

So I came up with something that look like this

```
SELECT friends.friend, users.avatar, COUNT(*) AS allfriends FROM users,friends

```

now what's that doesn't work. so I tried to group them but then I got a '1' for each row. so it was just count that individual row. My question is: is there a way to count a all the results and add them all together to give me a sum of what ever i retrieved of the tables