+} elsif ($authcat) {
+ my $query = qq{ SELECT * FROM authorised_values WHERE category=? order by lib };
+ my $sth = $dbh->prepare($query);
+ $sth->execute($authcat);
+ if ( $sth->rows > 0 ) {
+ for ( my $i = 0 ; $i < $sth->rows ; $i++ ) {
+ my $results = $sth->fetchrow_hashref;
+ push @authvals, $results->{authorised_value};
+ $labels{ $results->{authorised_value} } = $results->{lib};
+ }
+ }
+ $sth->finish;