Checkbox checked with database value

[vinpkl]

hi all

 

I have 3 checkboxes whose values are getting stored in the database with a comma separator.

 

<input name="color[]" type="checkbox" value="red" id="red" />red  
<input name="color[]" type="checkbox" value="blue" id="blue" />blue 
<input name="color[]" type="checkbox" value="green" id="green" />green

 

values getting stored with comma separator

 

red, blue, green

 

now i want to show the checkboxes as "checked" to show the customer as which colors they chose lasttime when they submitted the form.

 

How can i make it possible ?

 

If it is possible without the comma separator then i can remove the comma.

 

vineet

[Lyleyboy]

Ideally you would store each form field separately.

 

The code you are looking for is something like

 

Inside your record set while

if($row['red'] == 1){
        echo "<input type="chcekbox" checked"/>";
} else {
        echo "<input type="chcekbox""/>";
}

 

So if the field is set in the recordset the checkbox will display correctly.

 

Tadaa