Re: Those checkboxes again

Thanks, Joe! I see what you weer going after. I had several problems including the fact that I really didn't understand what I was trying to do until after I did it. And I had some log errors a friend helped with. What I needed to do was delete the media types from the intersection table and then insert them anew; that way I don't have to do all sorts of looping through finding the status of checked and unchecked boxes etc. Eventually I came to: if (isset($_POST['editrecordMedia'])){ if (!empty($_POST['media_types'])) { //TO make sure art_id isn't empty if (!empty($art_id)) { //delete media_art entries for this art_id $query="DELETE FROM media_art WHERE art_id='$art_id'"; mysql_query($query); $query = "INSERT INTO media_art (media_id,art_id) VALUES ";

                  $sep = "";

foreach($_POST['media_types'] as $type) { $query .= "$sep ('$type','$art_id')"; $sep = ", "; Anyway, thanks so much for your help!! JJ Joe Harman wrote:

if ($media_rows['art_id'] === $art_id) {

               $checkbox_media[] .= "checked ";
               }

               $checkbox_media[] .= "/>{$media_rows['media_name']}  ";

if think you only need 2 '=' signs... i do this alot with arrays of check boxes .. now don't quote me on this... but i do something like this.. using arrays for the check box values if($permissions_data <> NULL) { if(in_array($row_rsPermissions['permission_short_name'], $permissions_data)) { $checked_per = " checked"; } else { $checked_per = ""; } } hope that helps you out Joe On 6/16/05, Jack Jackson <jackson.linux@gmail.com> wrote:

hi, I'm severely frustrated and perhaps you can help with what I have done wrong. The checkboxes I use to populate an intersection table work to add the records, and now I am trying to update them. It's almost there but producing some unexpected results when the form is submitted: the idea is that it displays the checkboxes as pre-selected if they're associated with the art_id in the intersection table. They're now appearing as all unselected. Any help is appreciated. <?php $query = ''; $result = 0; $art_id = $_POST['art_id']; print_r($_POST); if (isset($_POST['editrecordMedia'])){

      if (!empty($_POST['media_types'])) {

              foreach($_POST['media_types'] as $type)
               {
                       $query = "UPDATE media_art SET
                       media_id='$type',
                       art_id='$art_id'";

var_dump($query);

                       mysql_query($query) or die(mysql_error());

               }
      }

      else {echo "mediatypes is empty";}
      //Closes if (!empty($media_types))

}//closes if (isset($_POST['editrecordMedia']) //If editrecord hasn't been set, but selectcartoon has, get the cartoon's recordset //This is just to get the title for display purposes $query = "SELECT art_title

      FROM art
      WHERE art_id='$art_id'";

//end

      $media_query = "SELECT media.media_id,
              media.media_name,
              media_art.art_id
              FROM media
              LEFT JOIN media_art
              ON media_art.media_id=media.media_id
              AND media_art.art_id='$art_id'";

//These $art results are just to get the title for display purposes $art_result = mysql_query($query); $art_rows = mysql_fetch_assoc($art_result); //end $media_result = mysql_query($media_query); $checkbox_media = array (); while ($media_rows = mysql_fetch_assoc($media_result)){

      $checkbox_media[] = "<input type='checkbox' name='media_types[]'

value='{$media_rows['media_id']}' ";

      if ($media_rows['art_id'] === $art_id) {
              $checkbox_media[] .= "checked ";
              }

              $checkbox_media[] .= "/>{$media_rows['media_name']}  ";

} ?> <table align="center">

       <tr><th colspan="4">Main Menu</th></tr>

<tr>

       <td><a href="addrecord.php">Add A Record</a></td>
       <td><a href="chooserecord.php">Edit A Record</a></td>
       <td><a href="deleterecord.php">Delete A Record</a></td>

</tr> </table> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="editrecordMedia"> <input type="hidden" name="art_id" value="<?php echo $art_id ;?>"> Choose media related to <strong><?php echo $art_rows['art_title'];?></strong><br /><br /> Media: <?php echo join($checkbox_media); ?> <input type="submit" name="editrecordMedia" value="Update"> </form> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php