What is the big complication?

[Marco van Herwaarden]

Originally Posted by Lionel

OK, as I am doing for 2 teams, here is the other serialize


PHP Code:
a:5:{i:0;s:0:"";i:1;s:4:"5 25";i:2;s:2:"15";i:3;s:2:"55";i:4;s:0:"";}

I am sorry but that don't make much sense to me. My Logic () tells me you will have a table structure something like:

Game
- gameid

GameTeam (2 rows per game, one for each team??????)
- gameid
- teamid
- totalscore

GamePlayers
- gameid
- teamid
- playerinfo
- gminutes2 (a serialized array containing the minutes of all goals scored by any player for this game/team)

As you see you are storing the minutes from all players in the row about a single player, then you want out of that array to retrieve only the goals, the current player has made. How can you know which array element you need for a player, and why store the info of all players in the row about a single player.


PS Maybe better if you also give your table structure and some sample data.