I have the following fields on my search page:

Name
Region
Type which has (Full, Allied, OTOC)

but the "Type" field doesn't work with the Name and Region fields. For example if I enter Wellington into the Region field and select Full it should bring up all the "Full" members in Wellington but it only brings up all the "Full" members (not all the full members in Wellington).

Hopefully that makes some sense.

sub query {
# --------------------------------------------------------
# First let's get a list of database fields we want to search on and
# store it in @search_fields

my ($i, $column, @search_fields, @search_gt_fields, @search_lt_fields, $maxhits, $numhits, $nh,
$field, @regexp, $line, @values, $key_match, @hits, @sortedhits, $next_url, $next_hit, $prev_hit,
$first, $last, $upper, $lower, $left, $right, $restricted);
local (%sortby);


if ($in{'search_field'}) {
$in{'Full'} = $in{'search_field'};
$in{'Allied'} = $in{'search_field'};
$in{'OTOC'} = $in{'search_field'};
$in{'ma'} = 1;
}



---- removed extra coding ----