Multiple Selection ListBox - Insert

[svgk01]

I am wrestling with my code for a list box, here is the code:

<form action=\"set_rosters.php\" method=\"post\">
<select name=\"playerID\" size=18 >

<option value=\"\">Select a Player</option>";

for ($i=0; $i<$number2; $i++) {
$playerID= mysql_result($result2,$i,"PlayerID");
$playerName = mysql_result($result2,$i,"PlayerName");
$nflTeamName = mysql_result($result2,$i,"NFLTeam.ShortName");

 print  "<option value=\"$playerID\" >$playerID, $playerName, $nflTeamName</option>";

}

$playerID, $playerName, $nflTeamName shows up in the ListBox, but it goes to insert the row, only $playerID is entered - do I need to change the value=\"$playerID\ portion? if so, how? Or do I need to parse the commas somehow??

Thank you.

[drew010]

yes, you must change the value=\"$playerID\ part. the following for example:
<option value="1234">Pick 1234!!</option>
when posted the value of that will be 1234, not pick 1234!!. if you want all three of the variables to go with the option list, you can either remove value and the value will be whatever text was selected, or put the 3 variables in the value portion.
I would recommend something like this:

<option value=\"${playerID}|${playerName}|${nflTeamName}\">

that way when posted, you can do this to get all the values.
list($playerID, $playerName, $nflTeamName) = explode("|", $_POST['playerID']);
and get all 3 values.