Adding multiple values in select box to db

[ffsja]

Does anyone know how to add multiple values from a select box to a mysql table?

Here's the code I'm trying to use to add multiple values:

foreach ($_POST['section_id']) {
$sql3 = "UPDATE $table_name13 SET
	date_id = '$_POST[date_id]',
	section_id = '$_POST[section_id]'";

$result3 = @mysql_query($sql3,$connection) or die(mysql_error());
}

Of course, this is not working. Anyone have any thoughts on how I might do this using PHP?

Thanks,
S./

[cahva]

You got the right idea to go throught the $_POST['section_id'] array, but forgot to add the necessary variable:

foreach ($_POST['section_id'] as $value) {
	$sql3 = "UPDATE $table_name13 SET
	date_id = '".$_POST['date_id']."',
	section_id = '".$value."'";

mysql_query($sql3,$connection) or die(mysql_error());
}

BTW, you should do a check for those $_POST vars. Never trust variables coming from forms you know..

[ffsja]

I'm still getting errors with my foreach() code. Specifically I'm getting the following error when I click 'submit':

Invalid argument supplied for foreach() - what does this mean?

Here's the code I am using as you suggested:

foreach ($_POST['section_id'] as $value) {
	$sql3 = "UPDATE $table_name13 SET
	date_id = '".$_POST['date_id']."',
	section_id = '".$value."'";

$result3 = @mysql_query($sql3,$connection) or die(mysql_error());
}

Here's the code from the previous page that populates the select box:

while ($row = mysql_fetch_array($result5)) {
$section_id = $row['section_id'];
$section = $row['section'];

$option_block5 .= "<option value=\"$section_id\">$section</option>";

}

Then, in the actual form:

<label for="section_id">Sections: </label><br />
<select name="section_id" style="width:100px" multiple="yes" size="6">
<? echo "$option_block5"; ?>
</select>

What's wrong with this code?

S./

[cahva]

In the actual form:
<select name="section_id"

.. Change it to:
<select name="section_id[]"

The error with foreach was that the $_POST['section_id'] was not an array. Now its an array when you change its name(add [] to end).

[LoganK]

Nice advice cahva!

Is this resolved now?

[ffsja]

Thanks cahva - I should have realized that.

Unfortunately it's still not working. :queasy: I'm not getting any more errors but it's not entering the data into the tables. Any ideas?

Thanks again,
S./

[LoganK]

Still not working? That's odd...

Try print_r($_POST) and see if it recognizes your select box as an array.

[ffsja]

Wow - that was a really interesting statement. Here's what I got:

Array ([section_id] => Array ( [0] => 1 ) [team_id] => Array ( [0] => 2 [1] => 4 [2] => 3 ) ....more fields

Looks like it's an array...

S./

[LoganK]

Yup, it's an array allright...how about you echo $sql3 so we can see what MySQL is receiving?

[ffsja]

OK - I think the main problem was that I was trying to update data that hadn't been entered yet. So I added the script to the insert page in this fashion (after the insert to date statement):

//first i get the date_id from the recently entered record

$date_id = mysql_insert_id();

//then i perform the insert statement for the dates table

$result = @($sql,$connection) or die(mysql_error());

//then i go through each section value in the array and assign it to $sql3

foreach ($_POST['section_id'] as $value) {
$sql3 = "INSERT INTO $table_name8 (date_id, section_id)
values ($date_id, (section_id = '".$value."'))";

//then i perform the query

$result2 = @($sql3,$connection) or die(mysql_error());

}

Date is now being entered into the sections_x table but every value pair is date_id = 0 and section_id = 0 no matter what i enter.

Any more suggestions?

S./