A new group has been entered into the address book. return to the group page
";
// -- Add people to a group
} else if($new) {
?>
Group has been removed. return to the group page";
}
else if($add)
{
// Lookup for the group_id
$sql = "select * from $groups_from_where AND group_name = '$to_group'";
$result = mysqli_query($db,$sql);
$myrow = mysqli_fetch_array($result);
$group_id = $myrow["group_id"];
$group_name = $myrow["group_name"];
// Add people to the group, who are not alread in the group!
if(isset($selected)){
foreach($selected as $user_id)
{
$sql = "insert into $table_grp_adr (domain_id, id, group_id, created, modified)
values ($domain_id, $user_id, $group_id, now(), now())";
$result = mysqli_query($db,$sql);
}
echo "
No users selected. Please use the checkbox to select a user.
";
}
}
// -- Remove people from a group
else if($remove)
{
// Lookup for the group_id
$sql = "select * from $table_groups where group_name = '$group'";
$result = mysqli_query($db,$sql);
// $resultsnumber = mysqli_num_rows($result);
$myrow = mysqli_fetch_array($result);
$group_id = $myrow["group_id"];
$group_name = $myrow["group_name"];
// Remove people from the group, who are not alread in the group!
foreach($selected as $user_id)
{
$sql = "delete from $table_grp_adr where id = $user_id AND group_id = $group_id";
$result = mysqli_query($db,$sql);
}
echo "