$dbq1 = $dbh->prepare(q{SELECT name FROM mytable WHERE id = ?}q);
$dbq2 = $dbh->prepare(q{SELECT age FROM mytable WHERE id = ?});
$dbq3...