Re: Getting checkboxes as array

Thank you Sebastian! Saved me some hell there!! On 6/9/05, Sebastian <sebastian@broadbandgaming.net> wrote: > Don't forget to mention that even if you don't select a checkbox it will > still add a empty record to the db.. i know for sure the foreach loop > will add a record even if a box is not check, so you have to check its > actually set before you start inserting. > > Richard Davey wrote: > > >Hello jack, > > > >Friday, June 10, 2005, 2:16:06 AM, you wrote: > > > >jj> $query = "INSERT INTO media_art (media_art_id,art_id, media_id) > >jj> VALUES ('','" . $art_id . "','" > >jj> . $media_types[2]. "')"; > > > >jj> repeat as many or few times as possible to account for the number of > >jj> checked boxes, such as > > > >One way: > > > >for ($i = 0; $i < count($media_types); $++) > >{ > > $query = "INSERT INTO media_art (media_art_id,art_id, media_id) > > VALUES ('','$art_id','{$media_types[$i]}')"; > > // perform query here > >} > > > >Another: > > > >foreach ($media_types as $type) > >{ > > $query = "INSERT INTO media_art (media_art_id,art_id, media_id) > > VALUES ('','$art_id','$type')"; > > // perform query here > >} > > > >Best regards, > > > >Richard Davey > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >