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();