| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Soccer database
I'm currently working on my club website and I want to make a database for storing matchresults, teams, players etc. and an updated league table. The league table should be updated automatically when a match is registered. I have been working on a database but I cant figure out an effective way to register and showing information. The problem is the match table and the update of the league table. I would greatly appreciate any help.
I want to store the following information: Season Matches MatchType MatchPlace Opponent Goals Yellow / Red Cards Substitutions Injuries MatchComment Referee Players Playerspositions Teams (Men, women etc.) It is possible that I have forgotten som elements that should be a part of the database. Feel free to add fields or tables. Thanks in advance
__________________
Wise men don't need advice. Fools wont take it. |
|
#2
|
|||
|
|||
|
Kaldorn, I may be missing something but what I don't see is a matchID column. Your database table for the matches has to have a primary key / unique identifier. As the information (shown below) is entered and submitted from a form, the database will automatically create the next matchID number. You can then display the info for any given match by a number of methods, Date, Location, Team Name ...
Does that help? |
![]() |
| Viewing: Tutorialized Forums > Databases > DB Design > Soccer database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|