Question for Clan Website Developers

[ShoeLace1291]

I have a question for people that have experience in developing websites for gaming clans.  I want to have a match database that's categorized by matches that have been played and matches that are on the schedule... i.e. upcoming matches and recent matches.  Judging by your own personal experiences, what do you think is the best way to store matches and their results?  Should I store scheduled matches and match results in separate tables?  How would you store these matches?

[wolfcry]

If you don't really care about duplicate data, store it all in one database that way it'll make querying a bit easier (not requiring JOINs etc.)

 

A basic DB structure I've done for this sort thing was like:

 

Table: ClanMatches
Team_A | Team_B | Scheduled_Match_Name | Match_Date_Time  | Winning_Team | Losing_Team | Winning_Score | Losing_Score |

 

Then you simply query the rows and display them as you see fit. Mind you, this isn't the best method if you're looking for cardinality but it's more than enough if you're running a simple clan site.

[scootstah]

You should store results and matches in different tables. This is called normalization, and is the preferred approach.

[KevinM1]

You should store results and matches in different tables. This is called normalization, and is the preferred approach.

 

This.

 

MySQL is a relational database.  If you have data that's separated but related to other data, then normalize their relationship.  Using a RDB like a giant spreadsheet means you're likely doing it wrong.