Form help

RabPHP

I'm trying to take 20-30 features of an item, and insert them into 1 field within a MySQL database and seperated with a comma.

I know I have to name all these features the same, but with a different value.

The form features are check boxes. I don't want to have create a new insert statement for each feature into a seperate field. Is there anyway to do this? Help appreciated. Thanks!

Dan

bernouli


foreach($features as $value) {
    $new_features .= $value . " , ";
}

$query = mysql_query(" INSERT INTO `Table` (`field`) 
	                 VALUES '$new_features') ");

RabPHP

Appreciate the help, but this didn't work for me. I have the field set to "blob". I also tried to print the results to the screen, and the variable isn't being defined.

The form is posting to itself, and I tried your statement several different way. Thanks though!

Dan

RabPHP

Nevermind! I added [] to the end of the names of the checkboxes, and this appears to have fixed it. Thanks!

RabPHP

I appreciate the help thus far. One last question though, using the same form layout, I want to make this item editable. How would I pull the data back out and seperating it back into the boxes so they are checked if that item is set.

I was guessing I could have it do a search of that field for text, and if it finds something like that value, it would set the check to true?

Dan