forms, select multiple, mysql

Anon

hi,

i've got a form that has various components. Some are freeform text entry, others are select one from a list and then there is a select multiple option.

For the select multiple option, it may be working, but when I look in mysql, all I see for the particular column is 'Array'. How do I view all of the values in the column rather than literally - 'Array'?

I want to see all columns in the row, where one of the columns is currently showing 'Array'.

Thanks for any help...

brainiac

The example below will extract the values from the array and seperate them with commas.
Uncomment and modify the mysql_query for your needs.

<?php
if ($doit == "true") {
for ($i=0; $i < sizeof($selectbox); $i++) {
$selects = $selects.",".$selectbox[$i];
}
$selects = substr($selects,1);
#mysql_query("INSERT INTO table VALUES($SELECTS);");
echo $selects;
exit;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>
<title>Multiple Select form</title>
</head>
<body>
<form action="<? echo "$php_self?doit=true"; ?>" method="post" name="thisform">
<select name="selectbox[]" multiple size="5">
<option value="1">option1</option>
<option value="2">option2</option>
<option value="3">option3</option>
<option value="4">option4</option>
<option value="5">option5</option>
</select>
</form>
<br>
<a href="javascript:document.thisform.submit();">Submit</a>
</body>