Inserting data into mysql db set field

skydive1

Hi All,

I have a web form with a multiple select option box that is populated from a db. I want to be able to select one or more of the items in the select box and insert them back into the db under a different row (a row for each customer when I submit the form).

I'm assuming that I can pass the info to the db in an array but I can't get the insert to work correctly.

This is how I pull the data from the db to populate the select box.

<select name=category_array[] multiple size=10>
<?
for ($i=0; $i<count($category_options); $i++) {
?>
<option value=<?=$category_options[$i]?>><?=$category_options[$i]?></option>
<?}?>
</select

Once teh user has selected one or more of the items, how do I insert that back into the db?

Thanks,

Rob.

Anon

First off there is no database query here so that would help if you had that. and to insert something back into a db you just use the insert with mysql

INSERT INTO tablename SET item1='$this', item2='$this3'

and so on

skydive1

Here is my code snippet:

$db = @mysql_select_db($db_name, $connection) or die ("Could not select database.");

//Array from select box
$count=count($category_array);
for ($i=0; $i<$count; $i++) {
$category_options = implode(',', $category_array);
}

echo "<br>$category_options";

$sql = "INSERT INTO $table_name (id, cname, caddress1, caddress2, caddress3, ccity, cstate, czip, ccountry, ctel, cfax, fname, email, mtype, listing_type, category_array[]) VALUES
(\"\",\"$cname\",\"$caddress1\",\"$caddress2\",\"$caddress3\",\"$ccity\",\"$cstate\",\"$czip\",\"$ccountry\",\"$ctel\",\"$cfax\",\"$fname\",\"$email\",\"$mtype\",\"$listing_type\",\"$category_options\")";

$result = mysql_query($sql, $connection) or die ("Could not execute database query.");

Now, the

echo "<br>$category_options";

statement shows me that I have the correct data to insert. It gives me an output like:

Builder,Appliances,Appraiser,Banks,Bonding,Brokerage

But the $result statement always gives an error and I can't figure out why.

Any suggestions greatly appreciated.

Rob.