Multi Selection

From: 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

« previous php.general (#150044) next »