I have started making a website for a football league.
The spec has changed since starting it and now I am stuck as it requires a lot more functionality then originally set out.
What I need to do is create a system where a season is defined, and matches are "setup" as fixtures.
The customer wants the fixtures to be automatically generated so each team will play another team twice. The dates and times and goals will be entered later.
Once the game as been played, the number of goals are entered into the site and the player who scored the goal will be entered too.
The player will have his stats updated to show how many goals he has scored, how many yellow cards, and red cards and "man of the match" he has in the current season.
I then need a results table of all the teams and all the points each team has gained in the season from the games played and the goals scored.
I have the most problems with the results table as I do not know how I will get this to calculate the score for each team.
1 goal scored = 1 point
Winning team = 3 points
if its a draw = 1 points
if its 0 - 0 = 0 points
I have attached a screen print of another site that has this working.