Adding up rows

[Smackie]

I'm currently trying to make a page where it shows each each user and how many games, kills, wins, draws, and bonus. not sure on how I would get it done. I'm currently on my business computer which i can't access my source codes on my home computer but i was wondering if someone might be able to direct me in the right way of making it so when i get home from work i can get the script done. (this is for a online community site i use to play games and chill after work lol)

Thank you
Smackie

[leatherback]

hm.. without specific code & database structure, it is a bit hard, but you would be looking at a quesry like this:

select sum(kills) as total_kills from TABLE were SOMEWHERESTATEMENT group by USERID