MySQL

insert checkbox values to database

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2008

Posts: 22

Reputation: skinbug is an unknown quantity at this point

Solved Threads: 0

skinbug

Offline

Newbie Poster

insert checkbox values to database

Aug 6th, 2008

Bit of a php and sql issue, so thought I'd try here...

for a registration form, I have created an sql file such as...

firstname varchar(30) not null
...etc...for all the fields, which I then import to the database.

But then the form also has 15 checkboxes where the user may or may not check them. The checkboxes are hard coded and they all have the same name in an array, eg...

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<input type="checkbox" name="nature[]" value="0" />
<input type="checkbox" name="nature[]" value="1" />
<input type="checkbox" name="nature[]" value="2" />
<input type="checkbox" name="nature[]" value="0" />
<input type="checkbox" name="nature[]" value="1" />
<input type="checkbox" name="nature[]" value="2" />

...etc...

The issue I am having is understanding how these values are stored in the database, since I have not created any rows in the sql file for the checkboxes. When I create the table and import it to the database, do I need to create one/some for the checkbox values???

Much help needed and appreciated, thanks!