$sth = $dbh->prepare(qq{select * from `table`});
$sth->execute();
my $_somevar = $sth->fetchrow_hashref();
$sth->finish();