Array List Menu Problems

[recset]

I am trying to store values from a List Menu into an sql database table as an ARRAY. However, when I select the multiple values from the form, it only stores the selected values as 'Array' in the SQL table.

Here is the Select Statement:
<select name="NOTES[]" size="9" multiple="multiple" id="NOTES">
<?php
do {

?>
<option value="<?php echo $row_literarydevices['LDEVICE']?>"<?php if (!(strcmp($row_literarydevices['LDEVICE'], $row_Recordset1['NOTES']))) {echo "selected=\"selected\"";} ?>><?php echo $row_literarydevices['LDEVICE']?></option>
<?php
} while ($row_literarydevices = mysql_fetch_assoc($literarydevices));
$rows = mysql_num_rows($literarydevices);
if($rows > 0) {
mysql_data_seek($literarydevices, 0);
$row_literarydevices = mysql_fetch_assoc($literarydevices);
}
?>
</select>

Can anyone offer a reason to why the values are not being stored?

Thanks.

[theelectricwiz]

recset wrote:

However, when I select the multiple values from the form, it only stores the selected values as 'Array' in the SQL table.

Hello,

It sounds like you are trying to just store $POST['NOTES'] as is. Try converting the array to a string by using the implode function eg.

$string = implode(",", $_POST['NOTES']);

The explode function can then be used to split the string up again when required.

http://nz.php.net/manual/en/function.implode.php
http://nz.php.net/manual/en/function.explode.php

Hope this helps