Hi all,
I'm trying to code an interface through which my administrative manager can keep track of the forms we've received in from my students, among other things. This information in turn would be displayed to parents/students when they log in. I'm having trouble storing multiple values to one field in my MySQL database. Right now the form looks like this:
Last Name: (input)
First Name: (input)
Role: (input)
Forms received:
(checkboxes)
[] Audition Form
[] Cast Contract
[] Health Form
[] Photo Release
(I'm not including the code because I've screwed around with it so much, it's pretty much useless.)
So, my question is, is there a code that would allow me to store multiple values via checkboxes in a single field in my database while submitting all the other information at the same time? I've seen a lot of codes using arrays with a separate query, but that would require running two different queries (one for the checkboxes and one for the input fields).
Also, it would be nice if, after the checkboxes are checked, they would remain checked unless manually unchecked so we can quickly see the forms that have already been submitted when updating the other information.
I hope I was clear enough. If you WANT to see the code I'm trying to use, I'd be more than happy to post it.
Thanks,
Brendan
