I really really cant get my head around this, i've thought about this for ages to the point of frustration that now im coming on here looking for advice. I have just started learning php and sql so for all i know its probably really simple. I want to create a football application with leagues, fixtures, and results for a pc football game that a group of us in college play. The idea is this,
User can log in. Manage a team, check fixtures, update their match results, view results, and check league table.
I can do pretty much all of this except for the fixtures/results. Here is my database so far, for what it's worth.
team_id FK (referencing id of tblTeams)
This is where im stuck. Should tblFixtures be like this instead:
Ultimately, what i want to achieve is this. User logs in, checks fixture. Plays against opponent. The home player reports match, puts in score, submits. The away player gets sent the report to accept/deny. Then that saves to the database, updates results table and and league table. Can anyone give me advice to understand how to do this?