getting multiple valus from a list menu with multiple select

[gabrielkolbe]

I have a dynamically generated list, I want a user to be able to select more than one value, for each one of these values I want to add a seperate entry in to the db, I can seem to get an array with the $_POST[] value of the form, can any one give me some advice here?

here is the dynamic generated form..

 

	<select name="sub1" size="<?=$check?>" multiple>
<option>ALL</option>
<?

$query = "
SELECT 
resourcesubtype.Type, resourcesubtype.ID
FROM 
rates
WHERE AND resourcetype = ".$_POST['resourcetype'].""; 

$result = mysql_query($query);
$check = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
  echo '<option';
if ($row['ID'] ==$_POST['sub1']) {echo ' selected'; }
  echo ' value = '.$row['ID'].'>';
  echo $row['ID'].' '.$row['Type']; 
  echo '</option>';
}
  
?> 
</select>

[discomatt]

You want to use

 

<select name="sub1[]" size="<?=$check?>" multiple>

 

Then use

 

$_POST['sub1'] = implode( ',', $_POST['sub1'] );

 

Or just use print_r( $_POST['sub1'] ) to figure out what's happening.