Reducing the amount of queries

[phlow]

I have a mySQL database with one table containing the mebmbers of my (small) community and another table containing messages to the members.
Now I want to print out a table showing the amount of messages that have been written to each person, e.g.:

John: 5 messages
Carl: 37 messages
Ralph: 12 messages

What is the most performat way to do that?

I don't want to have as many queries as there are people in the community, cause that's ultra slow...

[Anon]

You can use a query like this

select count(messageid), member
from members left join messages
on members.memberid = messages.memberid
group by member