Updating records with an array

[ffsja]

I'm trying to update records using values selected from a multiple selection select box. Here's the code i'm using in the update page:

if (isset($_POST['team_id'])) {
foreach ($_POST['team_id'] as $value) {
	$sql4 = "UPDATE team_members_x SET
	date_id = '".$_POST['date_id']."',
	team_id = '".$value."' WHERE date_id= '" .$_POST['date_id']."'";

$result4 = @mysql_query($sql4,$connection) or die(mysql_error());
}	
}

This doesn't seem to update my records correctly though. Anyone have any ideas?

Thanks,
S./

[devinemke]

ffsja wrote:

This doesn't seem to update my records correctly though

be more specific. what is your data structure? what does your form look like?

[ffsja]

Here is where the select box is populated in the form:

while ($row = mysql_fetch_array($projteam)) {
$ids[] = $row['team_id'];
}

while ($row = mysql_fetch_array($result6)) {
$team_id = $row['team_id'];
$team_fname = $row['team_fname'];
$team_lname = $row['team_lname'];
if (isset($ids[0])) {
if (in_array($team_id, $ids)) {
$option_block6 .= "<option value=\"$team_id\" selected=\"selected\">$team_fname $team_lname</option>";
} else {
$option_block6 .= "<option value=\"$team_id\">$team_fname $team_lname</option>";
}
} else {
$option_block6 .= "<option value=\"$team_id\">$team_fname $team_lname</option>";
}}

And this (below) is where it is put into the form:

<label for="team_id">Team Members: </label><br />
<select name="team_id[]" style="width:200px" multiple="yes" size="6">
<? echo "$option_block6"; ?>
</select>

That's about it. Does this help?

Thanks,
S./