[PHP] Multi Selection

[Frank Keessen]

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