What you need to generate as HTML looks smth like this
---
<FORM method=post action=page.php>
<SELECT name='somename[]' size=10 multiple id='somename[]'>
<OPTION value='one'>First Thingie</OPTION>
<OPTION value='two'>Second Thingie</OPTION>
<OPTION value='three'>Third Thingie</OPTION>
<OPTION value='four'>Fourth Thingie</OPTION>
<OPTION value='five'>Fifth Thingie</OPTION>
</SELECT>
<INPUT TYPE='post'>
</FORM>
---
page.php should look a bit like this:
---
<?php
foreach($_POST['somename'] as $Key => $Value) {
$Query = 'INSERT INTO table (value) VALUES ('.$Value.')';
mysql_query($Query);
};
?>
---
What I'm not really sure about are the '[]' in the <SELECT
name='somename[]'> .. might wanna try to leave them out. Also, i'm not sure
if the value of $_POST['somename'] is always an array, also if one option is
selected.. If it gives an errer, just use something like:
<?php
if(is_array($_POST['somename'])) {
foreach($_POST['somename'] as $Key => $Value) {
$Query = 'INSERT INTO table (value) VALUES ('.$Value.')';
mysql_query($Query);
};
} else {
$Query = 'INSERT INTO table (value) VALUES ('.$_POST['somename'].')';
mysql_query($Query);
}
?>
Just to be sure of the correct POST data, I usually do a <?php
print_r($_POST); ?> .. just to test it..
Hope it has been of any help,
Wouter
-----Oorspronkelijk bericht-----
Van: Frank Keessen [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 3 juni 2003 20:55
Aan: [EMAIL PROTECTED]
Onderwerp: [PHP] Multi Selection
Hi Guys,
I'm trying to do the following:
I've got a multiple selection box build out of a query of table
<td><select name="VALUE[]" size="10" multiple id="VALUE[]">
<?
$query2 = "SELECT SomethingID, Somewhere FROM Someplace WHERE publiceer =
'yes' ORDER BY somewhere";
$result2 = mysql_query($query2) or die ("Error in query: $query2. " .
mysql_error());
if (mysql_num_rows($result2) > 0)
{
while($row2 = mysql_fetch_object($result2))
{
?>
<OPTION VALUE="<? echo $row2->SomethingID ?>"><? echo $row2->Somewhere ;
?>
<?
}
}
?>
</option>
</select>
The outcome is stored in the VALUE[]..
Now i want to have an INSERT query that insert each value seperatly..
So if there are 3 selections it must be repeat the INSERT query three
times...
Thanks for the help!
Frank
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
