I am trying to develop a php script that will enable me to show attendance figures at football matches in a grid format with home team down the left hand side and away teams in 16 columns.
I have two tables of data:
1. Teams with fields id,team_name
2. Attendances, with fields id, home_id, away_id,attendance.
I can't for the life of me work out how to get the grid to display the attendance figures in rows across the grid with the correct match attendance figures in the correct column.
can anyone help?