my $stmt = "SELECT * FROM $table WHERE $key_col = '$key_val'";
    my $sth = $dbhandle->prepare( $stmt );
    $sth->execute();

##</code><code>##

    my $stmt = "SELECT * FROM $table WHERE $key_col = ?";
    my $sth = $dbhandle->prepare( $stmt );
    $sth->execute($key_val);

##</code><code>##

    my $ref = $sth->fetchall_arrayref();
    $sth->finish();
    return map { $_->[$name_col] => $_->[$val_col] } @$ref;

##</code><code>##

    my $ref = $sth->fetchall_hashref([$name_col,$val_col]);
    $sth->finish();
    return map {@$_} @$ref;

##</code><code>##