Hello,
Forgive me if I ask something stupid, I am fairly new to PHP.
I am trying to set up a fantasy grand prix website and have all the data ready in four seperate tables in Mysql. I have joined them and get results in the form of team_id, team_name, team_choice, and score.
Each team has a unique ID and is made up of five components, each with a score.
I can easily display a list of each component and the score but I'm not sure how to go about creating a subtotal for each team.
Any ideas, greatly appreciated