Try the code below:
sub {
my $tags = shift;
my $table = $DB->table('JOBS_MASTER');
$table->select_options('GROUP BY SHORTREGION']);
my $sth = $table->select();
my $output = '<select name=SHORTREGION><OPTION>';
while (my $row = $sth->fetchrow_hashref) {
$output .= '<option value='.$row->{SHORTREGION}.'>'.$row->{LONGREGION}.'</option>';
}
$output .= '</select>';
return $output;
}
Hope that helps.
TheStone.
B.
sub {
my $tags = shift;
my $table = $DB->table('JOBS_MASTER');
$table->select_options('GROUP BY SHORTREGION']);
my $sth = $table->select();
my $output = '<select name=SHORTREGION><OPTION>';
while (my $row = $sth->fetchrow_hashref) {
$output .= '<option value='.$row->{SHORTREGION}.'>'.$row->{LONGREGION}.'</option>';
}
$output .= '</select>';
return $output;
}
Hope that helps.
TheStone.
B.