mySQL question

[jonzy]

I've got a sports stats script but am having trouble with my database design. I want to be able to show previous season stats as well as the current season.

When game stats are entered into the database, they are stored with the team id, but I realized that if a team ever changes their name, the stats in the previous season will show the new name (which no one will recognize). Similar problem with divisions, as they may change each season as well.

So now I'm feeling my database design is flawed and am wondering if there is a way to fix the above problem, or will I need a separate databse for each season?

Any advice would be greatly appreciated.
Thanks, jonZy 😃

[drawmack]

nah, if a team changes their name just create a new record and have your script set up so that if a team has no stats they do not show that way the old team name won't show on this year's list and this year's name won't show on last year's list.