require MySQL;
    my $mysql      = new MySQL or croak "can't create MySQL Object";
    
    my @sql_output = $mysql->get({
        values  => ('test1','test2'),
        table   => 'test',
        where   => "`type` = $id",
    });

sub get {

    my ($self,$arg_ref) = @_;

    my $prefix = $prefix_of{ident $self};

    ### get needed parameters:
    my @values      = $arg_ref->{'values'};     # ARRAY: value1, value2,...
    my $table       = $arg_ref->{'table'};      # string
    my $where       = $arg_ref->{'where'};      # sql-string, opt
    my $sort        = $arg_ref->{'sort'};       # sql-string, opt

    ### check if alle values are filled in:
    if(!@values || !$table) {
        croak qq{
            MySQL Error: Not all needed params (value, table)
            are specified!
            value: @values
            table: $table
        };
    }

    ### transform values to
    my $sql_formed_values = join '`,`', @values;

    die $sql_formed_values; #testing

}

	        MySQL Error: Not all needed params (value, table)
	        are specified!
	        value: test1
	        table: 
	     at module/Gallery/Category.pm line 61

my @sql_output = $mysql->get({
        values  => [ 'test1','test2' ],  # [] anstatt ()
        table   => 'test',
        where   => "`type` = $id",
});

sub get {
   my ( $self, $arg_ref ) = @_;
   # ...

   ### get needed parameters:
   my @values      = @{ $arg_ref->{'values'} };     # ARRAY: value1, value2,...
   my $table       = $arg_ref->{'table'};      # string
   my $where       = $arg_ref->{'where'};      # sql-string, opt
   my $sort        = $arg_ref->{'sort'};       # sql-string, opt
   ###

   # ...

my @array = ( 1, 2 );
my $a_ref = [ 3, 4 ];

print "@array\n$a_ref\n";