12-13-2018, 02:29 AM
Z_ChangeBranchCode.php
Missing the following fields:
`defaultshipvia`,
`deliverblind`,
`specialinstructions`,
I believe this should do it:
Missing the following fields:
`defaultshipvia`,
`deliverblind`,
`specialinstructions`,
I believe this should do it:
PHP Code:
$sql = "INSERT INTO custbranch (`branchcode`,
`debtorno`,
`brname`,
`braddress1`,
`braddress2`,
`braddress3`,
`braddress4`,
`braddress5`,
`braddress6`,
`estdeliverydays`,
`area`,
`salesman`,
`fwddate`,
`phoneno`,
`faxno`,
`contactname`,
`email`,
`defaultlocation`,
`taxgroupid`,
`defaultshipvia`,
`deliverblind`,
`disabletrans`,
`brpostaddr1`,
`brpostaddr2`,
`brpostaddr3`,
`brpostaddr4`,
`brpostaddr5`,
`brpostaddr6`,
`defaultshipvia`,
`specialinstructions`,
`custbranchcode`)
SELECT '" . $_POST['NewBranchCode'] . "',
`debtorno`,
`brname`,
`braddress1`,
`braddress2`,
`braddress3`,
`braddress4`,
`braddress5`,
`braddress6`,
`estdeliverydays`,
`area`,
`salesman`,
`fwddate`,
`phoneno`,
`faxno`,
`contactname`,
`email`,
`defaultlocation`,
`taxgroupid`,
`defaultshipvia`,
`deliverblind`,
`disabletrans`,
`brpostaddr1`,
`brpostaddr2`,
`brpostaddr3`,
`brpostaddr4`,
`brpostaddr5`,
`brpostaddr6`,
`defaultshipvia`,
`specialinstructions`,
`custbranchcode`
FROM custbranch
WHERE debtorno='" . $_POST['DebtorNo'] . "'
AND branchcode='" . $_POST['OldBranchCode'] . "'";