How to submit multiple values using a listbox

[dennismcdougall]

Can any one tell me how to submit multiple values from a list box? I believe it has something to do with Arrays or Loops but i'm not sure.

this is this list box code. As you can see it is populated by the products database.

Could somebody show me what the array loop thing is supposed to look like. So this list box submits multiple values. At the moment when you submit the form all that is entered into the database is the word Array not the values of the list box. Do I need to change the setting in the mySQL datbase. At the moment the field it is entered into is Text.

Code:
<select name="vehicle_type[]" size="20" multiple>
<?php do { ?>
<option value="<?php echo $row_rsProducts['vehicle_type']?>" ><?php echo $row_rsProducts['vehicle_type']?></option>
<?php } while ($row_rsProducts = mysql_fetch_assoc($rsProducts)); ?></select>

much appreciated

Thank you :0)

[Weedpacket]

That's right (except most people use while(){...} instead of do{...}while(), in case the result set is empty). The problem is probably how you're processing the returned results.

You're probably trying to just insert $_POST['vehicle_type'] into the database; that's an array, so to fit it into the SQL query PHP has to convert it into a string: "Array".

If all that is the case, then how do you want the array to be stored in the database?

[dennismcdougall]

Thanks man I got the answer else where

if (isset($POST["vehicle_type"]) && is_array($POST["vehicle_type"])) {
$POST["vehicle_type"] = implode(", ", $POST["vehicle_type"]);
$HTTP_POST_VARS["vehicle_type"] = $_POST["vehicle_type"];
}