Question on adding values together

2004-07-19 Thread MySQL User
Hi I have a hockey pool database and I want to be able to add each weeks totals (goals, assists, etc.) for the players on each team. Example: Team 1 may have Hossa, Redden, and Forsberg. If each of them scored 2 goals and 2 assists for week one, I want to be able to get the total of 12. Team

Re: Question on adding values together

2004-07-19 Thread SGreen
You will need to create another table. In it you will need a columns identifying what week it is, what team you are documenting, and the statistics you want to store. For individual player statistics, you will need yet another table. This one would have columns identifying the player, what