List Bos and PHP/MYSQL

[rettajm]

Hi!

I have a form that inserts data into a mysql table through PHP. On the form, I have a list box. I want to be able to insert multiple values of the list box into MYSQL. Is this possible? If so, how can I do this?

I have tried everying.

[devinemke]

<form action="" method="POST">
Please select multiple numbers:<br>
<select name="numbers[]" size=5 multiple>
<option>1
<option>2
<option>3
<option>4
<option>5
</select><br>
<input type="submit" name="submit" value="submit">
</form>

<?
if (isset($_POST['submit']) && isset($_POST['numbers']))
{
	echo 'possible SQL statements:<br><br>';
	foreach ($_POST['numbers'] as $value)
	{
		echo 'INSERT INTO table SET number = ' . $value . '<br>';
	}
}
?>

[rettajm]

devinemke

Thanks, but when I used this code it place "NULL" in the field instead of the value? What am I doing wrong

[devinemke]

post code

[rettajm]

Here is the code:
html:
<select name="ProgName[]" multiple style="font-family: arial; font-size: 10pt size="5">
<option value="All">All Travel &amp; Learn Programs</option>
<option value="AmRev">American Revolution Seminar</option>
<option value="CWC">Civil War Conference</option>
<option value="Road">Civil War Studies on the road</option>
<option value="Jeff">Jefferson Symposium</option>
<option value="Shakespeare">Shakespeare Seminar</option>
<option value="OXF">UVA Seminars at Oxford, England</option>
</select>

<?

if (isset($POST['submit']) && isset($POST['ProgName']))
{
echo 'possible SQL statements:<br><br>';
foreach ($_POST['ProgName'] as $value)
{
echo 'INSERT INTO tablename SET number = ' . $value . '<br>';
}
}
?>

[devinemke]

my example was just that: an example. i was just echoing out the values. you will have to contruct SQL statements based of the form data. here's a more practical example (again, i'm just guessing here at your actual data structure, adjust as necessary)

<form action="" method="POST"> 
<select name="ProgName[]" multiple size="7">
<option value="All">All Travel & Learn Programs</option>
<option value="AmRev">American Revolution Seminar</option>
<option value="CWC">Civil War Conference</option>
<option value="Road">Civil War Studies on the road</option>
<option value="Jeff">Jefferson Symposium</option>
<option value="Shakespeare">Shakespeare Seminar</option>
<option value="OXF">UVA Seminars at Oxford, England</option>
</select><br> 
<input type="submit" name="submit" value="submit"> 
</form> 

<? 
if (isset($_POST['submit']) && isset($_POST['ProgName'])) 
{ 
	mysql_connect('host', 'username', 'passsword');
	mysql_select_db('database');

foreach ($_POST['ProgName'] as $value)
{
	$result = mysql_query("INSERT INTO table SET ProgName = '" . $value . "'");
	if ($result) {echo 'INSERT OK<br>';} else {echo 'INSERT FAILED: ' . mysql_error() . '<br>';}
} 
} 
?>