in reply to Using placeholders, getting unexpected SQL errors
Where $dbh is your database handle.$phone_insert->bind_param(1, $row->{'cust_id'}); $phone_insert->bind_param(2, $adtID); $phone_insert->bind_param(3, $phoneNumberTypes->{'Day'}); $phone_insert->bind_param(4, $row->{'cust_phac'}); $phone_insert->bind_param(5, $row->{'cust_phpx'}); $phone_insert->bind_param(6, $row->{'cust_phsx'}); $phone_insert->bind_param(1, $row->{'cust_phex'}); $phone_insert->execute or die "$dbh->errstr\n";
|
|---|