'; ?> Administration 0){ for($i=0; $i0){ for($i=0; $i0){ $sql_user_mb_group = "SELECT mb_group.mb_group_id, mb_group.mb_group_name, mb_user_mb_group.fkey_mb_user_id FROM mb_user_mb_group "; $sql_user_mb_group .= "INNER JOIN mb_group ON mb_user_mb_group.fkey_mb_group_id = mb_group.mb_group_id "; $sql_user_mb_group .= "WHERE mb_user_mb_group.fkey_mb_user_id = $1 "; $sql_user_mb_group .= "ORDER BY mb_group.mb_group_name"; if(!$selected_user){$v = array($user_id[0]);} if($selected_user){$v = array($selected_user);} $t = array('i'); $res_user_mb_group = db_prep_query($sql_user_mb_group,$v,$t); while($row = db_fetch_array($res_user_mb_group)){ $group_id_user[$cnt_group_user] = $row["mb_group_id"]; $group_name_user[$cnt_group_user] = $row["mb_group_name"]; $cnt_group_user++; } /*INSERT HTML*/ echo "
"; /*filterbox****************************************************************************************/ echo ""; /*insert all user in selectbox*************************************************************************************/ echo "
USER:
"; echo ""; /*insert all group in selectbox********************************************************************/ echo "
GROUP:
"; echo ""; /*Button*******************************************************************************************/ echo "
"; echo ""; echo "
"; echo ""; /*insert user_group_dependence in selectbox**************************************************/ echo "
SELECTED GROUP:
"; echo ""; echo "
"; }else{ echo "There are no other users owned by this user." ; } ?>