mysql SUM() question

I have a table result where there are some fields, date, match_id, club_id and now I would like to make a ranking list, so I would like to summarize al the points form the points filed based on the club_id's eg

if I have:

club_id points
1 1
1 2
2 0
3 1

then I would like to get the rank order like:
club_id
1
3
2

if anyone understand what I'm trying to explain and have an idea to to make so I would be glad

.patrik

You might try something like SELECT SUM(points) as points, club_id FROM table GROUP BY club_id ORDER BY points. That's untested. A group by and an order by of some type should show you what you need, at any rate.

It worked great, thx a lot
.p