my $SQL1 = "INSERT INTO property (address_1, address_2, county, city, zip, description, status, bedroom) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; my $sth = $dbh->prepare($SQL1) or die $dbh->errstr; $sth->execute($address_1, $address_2, $county, $city, $zip, $description, $status, $bedroom); $sth->finish();