What is the big complication?

[Marco van Herwaarden]

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:

PHP Code:

$getallplayers2 = $DB_site->query("SELECT cclpinternational_players.*
  , predictions2.predscore2 as score2
  , predictions2.predplayer2 as players2
  , predictions2.predminutes2 as gminutes2 
  FROM " . TABLE_PREFIX . "cclpinternational_players
  LEFT JOIN cclpinternational_predictions as predictions2 
    ON((cclpinternational_players.teamid=predictions2.teamid2) 
  AND (predictions2.userid='$bbuserinfo[userid]'))
  WHERE teamid='$tid2' 
 ");
if ($DB_site->num_rows($getallplayers2) == 0)
{
 $playerlist2="<tr><td colspan=\"5\" align=\"center\"><p><span class=\"smallfont\"><strong><font 
 color=\"#99000\">Line up is not available yet or no line up</font></strong></span></p></td></tr>";
}
else
{
 while ($getplayers2 = $DB_site->fetch_array($getallplayers2))
 {
  $predscore2=$getplayers2['score2'];
  $playerid2=$getplayers2['id'];
  $playerlname2=$getplayers2['lname'];
  $playerfname2=$getplayers2['fname'];
  $playerposition2=$getplayers2['position'];
  $playernumber2=$getplayers2['number'];
  $playerinfo2=$getplayers2['info'];
  $playerphoto2=$getplayers2['photo'];
  $predplayer2="$playerlname2 $playerfname2";
  $player2=unserialize($getplayers2['players2']);
  $checked = (in_array($predplayer2, $player2) ? "checked" : "");
  $checkbox2 ="<input type=\"checkbox\" name=\"predplayer2[]\" value=\"$predplayer2\" $checked>";
  
  $predminutes2=implode(" ", unserialize($getplayers2['gminutes1']));
  $minutes2 ="<input type=\"text\" name=\"predminutes2[]\" value=\"$predminutes2\" size=\"10\">";  
  eval('$playerlist2 .= "' . fetch_template('soccer_predictplayer2') . '";');
 }  
}