Check box to save multiple records

hello i am newly use yii.

i want to use checkbox to save multiple Records.

here i have one database.

table contact:

id int

name varchar

date date

email varchar

qualification varchar

ref_from varchar

intrested_in_joining varchar

intrested_course varchar // in this field i use six checkbox.then the checkbox checked value are stored into in this

                              fied.all checkbox checked value are in one field.then How to store the checkbox checked 


                              value into this field ?

hm this is not the ideal approach. why are storing multiple values into one mysql field. You could use serialized data but I strongly suggest you normalize your DB. ie use separate table for the checkboxes

table contact:

id int

name varchar

date date

email varchar

qualification varchar

ref_from varchar

intrested_in_joining varchar

intrested_course varchar // in this field i use six checkbox.then the checkbox checked value are stored into in this

                              fied.

Id name date qualific ref_from intrested_in_joining intrested_course

1 abc 2012/03/03 MCA XYZ Today B.E

2 abc 2012/03/03 MCA XYZ Today M.Tech

3 abc 2012/03/03 MCA XYZ Today MBA

the intrested_couorse field are checkbox checked values.they are all time different.

Here the all fields are same but the intrested_course field are change then how to do this…?

how to possible this the all field are same but id and intrested_course are change.

how this will be possible ?

Please help me.