Re: PHP Database

You need to understand the relations between the entities in order to design the database, there are 3 types: 1 to 1: - one team has one couch, no team has more couches and no couch has more teams. - usually in one table (team_name, couch_name), but might be also in two interconnected with keys (team_id, team_name)(team_id, couch_name) 1 to many: - one team has more players, but every playes has only one team - two tables interconnected with key (team_id, team_name)(player_id, team_id, player_name) many to many: - each team plays with more team (this is many to many, but references to the same table, better example would be mailing lists and subscribers, lists have many subscribers and subscribers might participate in more mailing lists) - this is done using another table holding multiple references, but might hold also additional information (domestic_team_id, host_team_id, dom_team_score, host_team_score, match_date) this is about design, but you have to make it yourself, I don't know about it much

Steven Priddy wrote:

I am looking into how I can make a database like this one that is MySql controlled. http://www.uhlfans.com/uhlstats/ That is one of my partners sites but the guy that created the database can't or won't tell me how to build one myself for a different subject. Thanks for your help!