my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $sth = $dbh->prepare( $stmt );
$sth->execute( $myid );
my $results = $sth->fetchall_arrayref( {} );

# or

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $results = $dbh->selectall_arrayref( $stmt, undef, $myid );

##</code><code>##

my $sth = $dbh->prepare_cached( $stmt );