Multi Selection
| From: | Frank Keessen | Date: | Tue, 03 Jun 2003 18:55:29 +0000 |
| Subject: | Multi Selection | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-150044@lists.php.net to get a copy of this message | ||
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