Hello everyone! This is regarding PHP & MySQL.
I have a form that website users fill out and send me there comments. Using a PHP script I created, the comments are posted to a MySQL table and I retrive them via a private admin section.
My Questions:
How do I use HTML Form Checkboxes to collect multiple answers for one question? I'm using a Column Data String Type of VARCHAR to store the answers. I guess that is ok. Also, when the form is inserted into the database table the "Respond_Via" field only contains the word "Array". I guess my problem is I don't know how to get the checkbox responses out of the Array and into the column as the user's selected answers.
Also please let me know what the INSERT statement should look like. I'm also inserting TEXT and TEXTAREA input fields as well, so I'm not sure if I can insert those types at the same time as the checkbox type.
Here is the html I use for the form question.
All the checkboxes are named the same, which is I belive how it should be:
Code:
Preferred Response Methods:
<input type="checkbox" name="Respond_Via[]" value="E-mail" border="0"> E-mail.
<input type="checkbox" name="Respond_Via[]" value="Phone" border="0"> Phone.
<input type="checkbox" name="Respond_Via[]" value="Fax" border="0"> Fax.
<input type="checkbox" name="Respond_Via[]" value="Mail" border="0"> Mail.
<input type="checkbox" name="Respond_Via[]" value="None" border="0"> None.
Many thanks to anyone who can help me with this!
- Steve
Just incase you need to know.. my current setup is:
Solaris 2.7
Apache 1.3.3
MySQL Version 3.23.43
PHP 4.1.0 Apache Modules
Codewalkers Forums Sponsor:
July 3rd, 2002, 02:51 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
