Select Code to Download

my $sql = "select name,address,phone,email from my table where name='m
+ary'";
my $sth=$dbh->prepare($sql) or die "Couldn't prepare statement handle:
+ ".$dbh->errstr();
...
}
$sth->finish();

   push(@some_array, join(' ', @row));

my $sql="select name,address,phone,email from my table where name=?";
my $sth=$dbh->prepare($sql) or die "Couldn't prepare statement handle:
+ ".$dbh->errstr();
my $count=$sth->execute('mary') or die "Couldn't execute statement:".$
+dbh->errstr();