Here's what I have (simplified).

TABLE 1: players
id
player
goals
assists

TABLE 2: stats
id
week
player_id
goals
assists

Each week statistics are added to the [stats] table. I would like to update the [player] table with the sum of the values from the [stats] table.

For example,

If stats table contains the following data...
1, 1, 24, 1, 3
51, 2, 24, 0, 2
101, 3, 24, 0, 1

I would like to update the players table to...
24, Jimmy, 1, 6

Any guidance would be appreciated.

Thanks,
Andrew