SQL은 이전 글에서 동일하게 사용된 구조.

<code>

#################그룹 통합
/*
$merge="abc";

$str1="abcdef";
$str2="lmopp";
$str3="admins";

$merge_sql="select `GrpTitle`,`GrpId`,`GrpGenCode`,`GrpAdmin` from usergroup where GrpId like '$merge'";
$merge_result=mysqli_query($conn,$merge_sql);
$merge_check=mysqli_num_rows($merge_result);
if($merge_check < 1) { echo "해당 대상이 없습니다";}
else { 
while($merge_fetch=mysqli_fetch_assoc($merge_result)) {
$grpTitle=stripslashes($merge_fetch['GrpTitle']);
$grpId=stripslashes($merge_fetch['GrpId']);
$grpGenCode=stripslashes($merge_fetch['GrpGenCode']);
$grpAdmin=stripslashes($merge_fetch['GrpAdmin']);

}echo $merge_update="update  usergroup set `GrpTitle` = '$grpTitle', `GrpId` = '$str1', `GrpGenCode` = '$str2' ,
`GrpAdmin` = '$str3' where `Grpid` like 'abc' and GrpIdx >=1"; 
~~~merge run
}
*/
####################################################

/*그룹 해체
$break_sql="DELETE FROM usergroup WHERE `GrpId` = 'abcdef' and GrpIdx >=1";
~delete run
*/
</code>