$sel_subjects = array(); if (isset($_POST["subjects"])) { $sel_subjects = $_POST["subjects"]; } $list_name = mysql_real_escape_string(json_encode($list_name)); $list_desc = mysql_real_escape_string(json_encode($list_desc)); // edit list if ($action == "edit") { $mesaj = array(); $query = "UPDATE liste SET \n `name` = '" . $list_name . "',\n `desc` = '" . $list_desc . "', \n `public` = '" . $list_public . "' \n WHERE `list_id` = '" . $list_id . "'"; $result = mysql_query($query, $dbconnect); confirm_query($result); if (mysql_affected_rows() == 1) { $mesaj[] = "The list details have been updated."; } $rel_subjects = get_sel_subj_for_list($list_id); foreach ($rel_subjects as $subj_id) { if (!in_array((int) $subj_id, $sel_subjects)) { $query = "DELETE FROM rel_subj_list WHERE subj_id = '" . $subj_id . "' AND list_id = '" . $list_id . "'"; $result = mysql_query($query, $dbconnect); confirm_query($result); if (mysql_affected_rows() == 1) { $subj_name = get_subj_name($subj_id); $mesaj[] = "Subject {$subj_name} has been removed from list."; } } } foreach ($sel_subjects as $subj_id) { if (!in_array((int) $subj_id, $rel_subjects)) { $query = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')"; $result = mysql_query($query, $dbconnect);
} ?> /> <?php __("Private list"); ?> <br /> </fieldset> <fieldset> <label for="subjects"><?php __("Subjects included in the list"); ?> </label> <?php $sel_subj = get_sel_subj_for_list($list_id); $all_subjects = get_all_subjects(); while ($row = mysql_fetch_array($all_subjects)) { $subj_id = $row["subj_id"]; $subj_first_name = $row["first_name"]; $subj_last_name = $row["last_name"]; ?> <input type="checkbox" <?php if (in_array($subj_id, $sel_subj)) { echo "checked=\"checked\""; } ?> name="subjects[]" value="<?php echo $subj_id; ?>