[Resolved] most common row

[markepic]

I know this is dead simple, but the problem is so am I...
I have searched but cannot find the answer (it would help if I knew what to search for!).

Anyway, here is my problem:
I have a db table with many columns but I am really only interested in one of them: member_id.
A row is added to the table each time a member completes a 'transaction'.
So the member_id column is filled with many different ids some of them appearing more than once.
What I want to get is a list of the 10 ten members, i.e. the 'member_id's that appear most in the 'transaction' table (and the number of times they appear). How do I do this?

Many thanks.

[mrhappiness]

SELECT
  member_id, COUNT(member_id) entries
FROM tablename
GROUP BY member_id
ORDER BY entries DESC
LIMIT 10

something like that?

[markepic]

yeah, that's just the thing! thanks