Statistics?

[tokis]

Hi

I have a website that contains football news. I'm using wordpress and I want to add some new functions. I want to create post match review section, after each match/game to show goalscorers, lineups, statistics and review. For ex like this http://www.whoscored.com/Matches/720776/Live
My question what is the best way to create this thing? To create database for each team?

Thank you

[laserlight]

This starts with figuring out what you want to store and what you want out of the data, and then deciding on how to model the data. Unfortunately, the topic is too vast to cover in a forum post.

One place to start is to look at relational database systems, i.e., things like entity-relationship modeling and relational database normalisation.

[NogDog]

I would say, however, that it's 99.999% likely you do not want a separate database for each team, and 99.998% likely you do not even want a separate table for each team.