my $sql = {
     SELECT name
     FROM patient_data
     WHERE name = ?
  };
  my $sth = $dbh->prepare($sql);
  $sth->execute($name);
  my $count_rows = 0;
  while (my ($name) = $sth->fetchrow_array()) {
     ### do something with $name here ###
     $count_rows += 1;
  }