$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'] . "'";