I have 2 mysql? tables, I export both tables in the joined file.
There is a table called "players" that contains all the nhl players stats updated everyday. In my example 854 players X 3 days.
In the second table you can see 4 differents team, each team has 15 players. Each player has a start date (DD) and an optional ending date (DF).
I want you to make a standing shorted by total point? in PHP looking like this:
TEAM1, GAME PLAYED, GOALS, ASSISTS, TOTAL POINT
TEAM2, GAME PLAYED, GOALS, ASSISTS, TOTAL POINT
TEAM3, GAME PLAYED, GOALS, ASSISTS, TOTAL POINT
TEAM4, GAME PLAYED, GOALS, ASSISTS, TOTAL POINT
Game played = Sum of all games played by the 15 players of the team.
Goal? = Sum of all goals of the 15 players of the team.
Assist = Sum of all assists of the 15 players of the team.
TOTAL POINT = SUM of Goal + Assists