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