Select Code to Download

my $sql = {
     SELECT count(*)
     FROM patient_data
...
  my $sth = $dbh->prepare($sql);
  $sth->execute($name);
  my ($count_rows) = $sth->fetchrow_array();

$sth->finish();