adding an entire column in a MYSQL table

[wasson]

So here's the deal. I run a site where members submit photos and get points based on the photos they submit. I'd like to get their total points, but I'm at a loss on how to do that.

I have a mysql table set up with every photo that includes title, description, the user who submitted it, and the number of points that picture is worth. I'd like to write a query that goes through that table, and whenever the 'user' column matched the user, it added up the points in that row. It sounds easy, but for the love of me, I can't figure out the mysql commands to make it work. Any help at all would be awesome.

Thanks.

[bogu]

Try something like this:

SELECT user, SUM(points) FROM table GROUP BY user