open INPUT,'<',$out_file or die "Can't open file " . $out_file . "\n$!\n"; #Open for read while () { my $name = $connect->quote($_); my $address1 = $connect->quote(); my $address2 = $connect->quote(); my $phone = $connect->quote(); for () { next if /(Council|^Continuing|^Mapping)/; last; } my $overall = $connect->quote($_); my $inspections = $connect->quote(); my $staffing = $connect->quote(); my $quality = $connect->quote(); my $programs = $connect->quote(); my $beds = $connect->quote(); my $ownership = $connect->quote(); my $query_string = "INSERT INTO nursing_homes (name, address1, address2, phone, overall, inspections, staffing, quality, programs, beds, ownership) VALUES ($name, $address1, $address2, $phone, $overall, $inspections, $staffing, $quality, $programs, $beds, $ownership)"; #printVariables($name, $address1, $address2, $phone, $overall, $inspections, $staffing, $quality, $programs, $beds, $ownership, $query_string); my $query_handle = $connect->prepare("INSERT INTO nursing_homes (name, address1, address2, phone, overall, inspections, staffing, quality, programs, beds, ownership) VALUES ($name, $address1, $address2, $phone, $overall, $inspections, $staffing, $quality, $programs, $beds, $ownership)"); $query_handle->execute(); }