sws Posted November 28, 2006 Share Posted November 28, 2006 Hi,I've got a table in my database which stores all of the game stats for all of the players in the NHL. I update the totals in this table every night to show the acrrued totals for the entire season.I also need to show totals for any given day.That's where I'm stuck.What is the best way to update the database so that the total stats for the year are updated every night but I've also got a snapshot for any particular day as well.Any advice would be greatly appreciated. Link to comment https://forums.phpfreaks.com/topic/28763-updating-daily-stats-in-a-mysql-database/ Share on other sites More sharing options...
The Little Guy Posted November 28, 2006 Share Posted November 28, 2006 you will need to make a row for every day for every player Link to comment https://forums.phpfreaks.com/topic/28763-updating-daily-stats-in-a-mysql-database/#findComment-131645 Share on other sites More sharing options...
sws Posted November 28, 2006 Author Share Posted November 28, 2006 But the player id has to be unique.Does this mean that I need to make a players table containing just their unique id's and name and team and then another player stats table ?Probably huh ? Link to comment https://forums.phpfreaks.com/topic/28763-updating-daily-stats-in-a-mysql-database/#findComment-131650 Share on other sites More sharing options...
The Little Guy Posted November 28, 2006 Share Posted November 28, 2006 Id say yeah. Link to comment https://forums.phpfreaks.com/topic/28763-updating-daily-stats-in-a-mysql-database/#findComment-131663 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.