in reply to Insering into 2 tables?
This doesn't solve the problem you are asked, but please, use placeholders:
my $SQL1 = "INSERT INTO property (address_1, address_2, county, cit +y, zip, description, status, bedroom) VALUES (?, ?, ?, ?, ?, ?, ?, ?) +"; my $sth = $dbh->prepare($SQL1) or die $dbh->errstr; $sth->execute($address_1, $address_2, $county, $city, $zip, $descripti +on, $status, $bedroom); $sth->finish();
Unfortunately, placeholders can't be used on table names on most databases, or else the solution to your problem would be easy.
|
|---|