On Sat, 2008-03-15 at 00:33 -0400, John Taylor-Johnston wrote:
> Robert,
>
> >>>> Array
> >>>> (
> >>>> [0] => Hemmingford
> >>>> [1] => Huntingdon
> >>>> )
> > You want the following (otherwise each checked entry overwrites the
> > previous):
> > <input type="checkbox" name="checkregion[]" value="Knowlton" />
> > <input type="checkbox" name="checkregion[]" value="Thetford Mines" />
>
> How would you proceed?
>
> $sql ='insert into `database`.`table` (`Nom` ,`checkregion`)
> values ('John', '". ?? ."') ';
>
> I'm just guessing.

It depend son what you want to do with the data. It may be that you want
a row for every selected entry or it may be that you can just serialize
the data. Do you want to just have a snapshot of what the user chose? Or
do you want to be able to query the database about who selected
"Knowlton"? If the former, then you can get away with just serializing
the data, but if you want to be able to do queries, then you need to
store each entry in its own row.

Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP