Just as you have a name for each of the checkboxes on your existing form, you need to have a field for each of the checkboxes in your database. You would have something like:
Code:
Archery => [0, 'alpha', 0, 50, 0, '', ''],
Art => [1, 'alpha', 0, 50, 0, '', ''],
Associations => [2, 'alpha', 0, 50, 0, '', ''],
ATVs => [3, 'alpha', 0, 50, 0, '', ''],
Bait => [4, 'alpha', 0, 50, 0, '', ''],
Camp_Grounds => [5, 'alpha', 0, 50, 0, '', '']
Chats_Bulletin Boards => [6, 'alpha', 0, 50, 0, '', '']
Guides_Charters => [7, 'alpha', 0, 50, 0, '', '']
(I just used some of them for examples. You'll need to change the field numbers and fill in the rest, of course.)
The
50 field length above is arbitrary. You can set it to pretty much whatever you want, so long as it is at least the length of the value which will be put in the field.
A couple of things to watch out for -- with the ones that have spaces, &s or /s in them, it's better to use underlines in the field name. You can use the other characters when you define the checkbox fields. There might be a problem with the / character even then. I'm not sure.
When you define your checkbox fields, use
Code:
%db_checkbox_fields = (
Archery => 'Archery',
Art => 'Art',
Associations => 'Associations',
ATVs => 'ATVs',
Bait => 'Bait',
Camp_Grounds => 'Camp Grounds',
Chats_Bulletin Boards => 'Chats/Bulletin Boards',
Guides_Charters => 'Guides & Charters'
);
On your list at the moment, I didn't see anything with an apostrophe, but if you should need to use one, you need to put a \ before it like
Code:
Dont_call => 'Don\'t call'
------------------
JPD
