$sth = $dbh->prepare($statement);
$sth->execute(<placeholder values here>);
# retrieve results here
$sth->finish; # if there is any risk of not having fetched all the values