checkbox's

[Anon]

Hi,

I was hoping someone could give me some ideas on what I should be doing here. I have a php form that is connecting to a mySQL database. The form contains about 25 checkbox’s and about 15 data entry fields.

I wanted to know what was the most efficient way to store the checkbox data. I have read http://www.phpbuilder.com/columns/laflamme20001016.php3 but it did not seem like a good solution because of the number of checkbox's and I would like to have somewhere around 1,500 sets of the checkbox's.

So that would mean something like 22,500 records (say 1,500 * 15 checkboxes) just for the checkbox data. Would it not be better to just create a table with 15 fields to store the data then I would only have 1,500 records and not 22,500?

Thanks
- Justin

[Anon]

One record, 15 fields is a much better idea, particularly as the fields only need to be 1 char long.