Hi William
In your form, put the following HTML for each element of your checkbox:
<input type="checkbox" name="whatever[]" value="this tickbox's value">
This will put all the tickbox data for your checkbox into one array called $whatever.
Unfortunately, MySQL seems to return all values here with "Array", which is a complete waste of time (and therefore makes me wonder about the benefits of using checkboxes instead of ordinary fields ...).
To get the info back in a sensible format, you have to do as Saravanan suggested to me in an query I posted here a couple of days ago. That is, take your info from the form ($whatever), and pre-process it before the lines in your PHP script relating to the SQL insert:
$whatever=implode(", ",$whatever);
Then do the insert into the db:
$sql= "insert into tablename (...,whatever,...) values (...,\"$whatever\",...);
This at least gets you sensible human-readable stuff in your db field (though check that it is long enough to hold all the likely values of the checkbox elements).
As regards printing out values that have already been entered in as "Array", I'm still working on this - any suggestions anyone?. I'm sure it relates to using implode somehow.
Any comments on the benefits of arrays versus straight gfields would also be welcome (eg won't data entries of the above sort make it more difficult to do a search on a particular checkbox element?).
HTH
Kevin
