Inserting checkbox values into one field

[ebosysindia]

Hi

I have a checkboxes on my page (.aspx) like

checkbox1 - item1
checkbox2 - item2
checkbox3 - item3
etc

what i want is that when a user selects certain checkboxes
they should be inserted into a table called
customer which has fields (customer id and actions)

the data should be inserted as

customerid actions
1 item1,item2,item3
2 item1,item3
3 etc..

i.e all the values should be inserted into database into one field separated by commas.

Thanks

[grim1208]

are you familiar with php? if so perhaps this will help

//page form gets submitted to after checkbox select
#db connections la la
$customerId = $db['customerId'];
$numItems = count($_POST);
$customerPurchase = array();

for($i=0;$i<=$numItems;$i++)
{
  $data = $customerId + " " + $_POST[$i] + ",";
  array_push($customerPurchase, $data)  ;
}

#php & mysql code to inset $customerPurchase into whatever table la la

I typed this out on the fly without php localhost from friends computer, hope this helps

cheers

grim
newgameprojects.net

[stevepeterson]

I think grim1208 answer is right. Have you follow this one ?