$sth = $dbh->prepare("SELECT COUNT(*) FROM ?");
  foreach my $table_name (qw(table_one table_two)) {
    $sth->execute($table_name);
    my $rowcount = $sth->fetchrow_array;
    print "Number of rows in $table_name: $rowcount\n";
  }