What is the big complication?
 

The table says it clearly:
5 items are in array. Values are at item 2, 3 and 4 (counting from 0)
Theorically seems easy to reinsert those values in same array textboxes
so why is this not doing the job?

I guess what you want would be something like:

Thanks Marco. At least I am getting somewhere, but it displays all the values in all the textboxes.

5 25 should have been on the second line, 15 on the third and 55 on the fourth. Nothing for first and last. :tired:

Then please post a bigger part of your source. Impossible to see from this snippet exactly what you are trying to do, and advise you.

Here is the full code. I had the same problem with the checkboxes. See how I got around it

That was the original which displays only the last value in all boxes, then your changes.
I am using the same code for team1 versus team2 (opponent) renaming the queries 1 and 2

Sorry but i really can't advice, still not enough info. You are confusing with your examples. In the screenshot you are talking about the values 5, 25, 15 & 55, but the serialized array is showing totally different values.

I will need to know how to relate the array elements to the current player (PS if those 4 values are stored for 1 player, why don't they all apply to that player?)

Also posting the templates you are using might help.

....And, please please please, for yourself and others, do some decent line indentions, it will make your code so much easier to read.

PS I changed the above to the following, waiting on your feedback:

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

templates that I use

Main template

Soccer_predict template ($predict)

and playerlist1 soccer_predictplayer1 template (identical to playerlist2)

Wow, great code for the checkboxes. It works!!!

I am sorry but that don't make much sense to me. My Logic (:D) 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.

Here is a snaphop of my main predictions table

Here is how it works. Member comes on the site and select a game for predictions. He gets to put the scores for team1 and for team 2

then he gets to put who will score (from the checkboxes) and at what minute that score will happened in the textbox, separating 2 goals for same player by a space. (in my example I simulated a prediction for 5 goals and 4 inputs for minutes, one of them having scored twice, so same textbox has 2 value).

I have only one input per game per member, meaning in that structure I am posting in this post, a single line holds all the values serialized (although the prdplayer serialize was not necessary) . The rest is accomplish with LEFT JOIN. I am also posting how it looks in db.

And here is how I insert in the prediction table

Sorry but what you got is really confusing.

If you want help on this, send me you ICQ or MSN contact info in PM.