Storing multiple values from checkbox

[Shockbox]

Hi there,

I was wondering if someone could tell me how to store multiple checkbox values into a MySQL table?

I know how to work it with Python on its own but I need to store into a database.

Any ideas?

[simplypixie]

It depends how you want to store them in your database - all in one column or in multiple columns

[Shockbox]

I want it to store each checked box into a different field

[simplypixie]

In which case each checkbox must have a different name and the posted values from each can then be inserted into or updated in the database into the relevant fields.

[Shockbox]

I had tried that with no avail.

I tried using a for statement as well using mykey but it didn't work either.

[simplypixie]

Please post your form and php / query code as we cannot help without seeing it. Also if you get any errors, what are they?

[Shockbox]

This is what I currently have:

boxes = { "des" : "Website Design",\
          "svr" : "Web Server Administration",\
          "com" : "Electronic Commerce",\
          "mkt" : "Web Marketing/Advertising",\
          "edu" : "Web-Related Education" }

store = form['boxes'].value
comments = boxes[store]

This is currently returning an error: <type 'exceptions.KeyError'>: 'boxes'
args = ('boxes',)
message = 'boxes'

I want the user to be able to click on the checkboxes and for the checked boxes to be stored into a database field.