Okay, what I want to do is design a database and a PHP script to run and calculate sports standings. This script would need to be able to calculate the number of overall wins and losses, winning percentage, games back, and most importantly, conference wins and losses.
I want to be able to enter game results and have the standings update automatically, but I am unsure how to go about it.
I would need to have a Date field, a field for the Home Team, a field for the home team's score, a field for the away team, and a field for the away team's score.
But, how could I also mark that as a conference game so that the standings script would calculate the W/L for conference games only...
Let me know if I need to explain this further...
