Select Code to Download

my $q1 = $dbh->prepare("sql statement");
my $q2 = $dbh->prepare("sql statement 2 with ?");
...
      # code here
   }
}

my $sth = $dbh->prepare("select * from table where field = :nam");
$sth->bind_param(':nam', $value);
$sth->execute();