';
?>
Add Filtered User to Filtered Group
0){
for($i=0; $i0){
for($i=0; $i0){
$v = array();
$t = array();
$sql_mb_user_mb_group = "SELECT mb_user.mb_user_id, mb_user.mb_user_name, mb_user.mb_user_email, mb_user_mb_group.fkey_mb_group_id FROM mb_user_mb_group ";
$sql_mb_user_mb_group .= "INNER JOIN mb_user ON mb_user_mb_group.fkey_mb_user_id = mb_user.mb_user_id ";
$sql_mb_user_mb_group .= "WHERE mb_user_mb_group.fkey_mb_group_id = $1 ";
if(!$selected_group){array_push($v,$group_id[0]); array_push($t,'i');}
if($selected_group){array_push($v,$selected_group); array_push($t,'i');}
$sql_mb_user_mb_group .= " AND mb_user.mb_user_owner = $2 ";
array_push($v,$logged_user_id);
array_push($t,'i');
$sql_mb_user_mb_group .= " ORDER BY mb_user.mb_user_name";
$res_mb_user_mb_group = db_prep_query($sql_mb_user_mb_group,$v,$t);
while($row = db_fetch_array($res_mb_user_mb_group)){
$user_id_group[$cnt_group_user] = $row["mb_user_id"];
$user_name_group[$cnt_group_user] = $row["mb_user_name"];
$user_email_group[$cnt_group_user] = $row["mb_user_email"];
$cnt_group_user++;
}
/*INSERT HTML*/
echo "";
}else{
echo "There is no group available for this user.";
}
?>