my $sth = $dbh->prepare('SELECT firstname, lastname FROM user WHERE age >= ? ORDER BY age desc LIMIT 200');
$sth->execute(...);

my $row = undef;
while ($row = $sth->fetchrow_hashref) 
{
   print $row->{ firstname }, ' ', $row->{ lastname }, "\n";
}