Here's a nifty trick.

Name your check boxes like this.

<input type="checkbox" name="myarray[]" value="value1" />
<input type="checkbox" name="myarray[]" value="value2" />
<input type="checkbox" name="myarray[]" value="value3" />
<input type="checkbox" name="myarray[]" value="value4" />

Then when it posts back to php, you will have a nice array. Lets say that 
they tick all but value2, then you will have:

$myarray == array("value1", "value3", "value4");

I guess the order in which they appear is arbitrary, but that makes no 
matter for a MySQL enum. So just do an implode on the array to put it in 
the database.


Owen Prime

John wrote:

> I'm new at using PHP and mySQL, so please forgive my potentially naive
> question.
> I have a series of checkboxes with different values.  The user can select
> any number of checkboxes, and I need to store this information in a mySQL
> table.
> 2 questions:
> Should I have a unique form name for each checkbox, and store it's boolean
> value in the database, OR (is it more streamlined) ..
> To create an array <input type=checkbox name=apps value =myarray[$i]> with
> the same name but different value for each checkbox.
> Finally, how do I construct the query to store the array of values?  Do I
> need a separate column (enum('n','y') for each value, or should I store
> all the true values as a long text string?
> If anyone has some code snippets, that would help very much.
> Thanks very much!

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to