I am a novice programmer, I can handle simple data sites but this one is starting to be more than I can handle.

Currently I have the admin area set up so all the coaches can login with a username and password so they can update the scores of the games and the standings in separate tables.

The problem is that not all coaches are doing the standings.

I would like to modify the admin area so when the coach updates the score of the game, I can get them to update the standings table at the same time.

Can someone give me some advice on where to find some help? A good book perhaps?

I have a few ideas,

When the score is entered, the site will calculate the winner based on the higher score and add one win to the winning team (3 points) one loss to the losing team (0 points) add in the goals for and goals against for each team and add one game played to both.

The other idea is to keep it simple, when the coach enters the score it updates the Schedule table and then when you click update the site will take you to the standings page with both teams that were in the previous game (or all teams in that league) and modify the goals for and against, games played, wins, losses, ties, total points manually, but with one click to update it updates all records on that page.

I am not sure where to go, help please!!