array( "Back to groups" => "policy-group-main.php", "Back to members" => "policy-group-member-main.php?policy_group_id=".$_POST['policy_group_id'], ), )); # Display change screen if ($_POST['frmaction'] == "change") { # Check a policy was selected if (isset($_POST['policy_group_member_id'])) { # Prepare statement $stmt = $db->prepare("SELECT ID, Member, Comment, Disabled FROM ${DB_TABLE_PREFIX}policy_group_members WHERE ID = ?"); ?>

Update Policy Group Member

execute(array($_POST['policy_group_member_id'])); $row = $stmt->fetchObject(); $stmt->closeCursor(); ?>
Old Value New Value
Member member ?>
Comment comment ?>
Disabled disabled ? 'yes' : 'no' ?>

No policy selected

Policy Group Member Update Results

quote($_POST['policy_group_member_member'])); } if (!empty($_POST['policy_group_member_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['policy_group_member_comment'])); } if (isset($_POST['policy_group_member_disabled']) && $_POST['policy_group_member_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['policy_group_member_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}policy_group_members SET $updateStr WHERE ID = ".$db->quote($_POST['policy_group_member_id'])); if ($res) { ?>
Policy group member updated
Error updating policy group member!
errorInfo()) ?>
No changes made to policy group member
Invalid invocation