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

__versus__

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