Re: Re: <input type="checkbox">

On Sat, 2008-03-15 at 01:00 -0400, John Taylor-Johnston wrote: > Robert Cummings wrote: > > 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. > > It would look like: > > $sql ='insert into database.Y���gn�w E > 7��7table (Nom > ,checkregion) > values ('John', 'Montreal,Knowlton,anything') '; > > checkregion[5] = "Montreal"; > checkregion[7] = "Knowlton"; > checkregion[55] = "anything"; > > I need to unarray checkregion[] and break it up into separate words and > then separate them by commas. $regions = implode( ',', $checkregion ); $sql = "INSERT INTO database.table " ."( " ." Nom, " ." checkregion " .") " ."VALUES " ."( " ." '".mysql_real_escape_string( $nom, $conn )."', " ." '".mysql_real_escape_string( $regions, $conn )."' " .") "; Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP