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 game it was, (optionally) what week the game was played, and any additional columns you need to hold the stats for that player for that game. You are on the right track, you just need to expand you current model to hold the additional information. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "MySQL User" <[EMAIL PROTECTED]> wrote on 07/19/2004 12:12:04 PM: > 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 > two has three different players and they may score 3 goal and three assists > for a total of 18. Then team 3, 4, 5, etc. > > I have three tables, one with the teams (I call it manager) and one for the > players (called roster). I have a reference table that links the manger and > roster tables together to determine what players are on what teams. > > Any help is appreciated. > > CR > > > >
