my $sth = $dbh->prepare("UPDATE kunden SET kdfirma = ? WHERE kdnummer = ?"); $sth->execute($kdfirma, $kdnummer);