$sql = "INSERT INTO suppliers (`supplierid`,
`suppname`, `address1`, `address2`, `address3`,
`address4`, `address5`, `address6`, `supptype`, `lat`, `lng`,
`currcode`, `suppliersince`, `paymentterms`, `lastpaid`,
`lastpaiddate`, `bankact`, `bankref`, `bankpartics`,
`remittance`, `taxgroupid`, `factorcompanyid`, `taxref`,
`phn`, `port`, `email`, `fax`, `telephone`, `url`,
`defaultshipper`, `defaultgl`)
SELECT '" . $newCode . "',
`suppname`, `address1`, `address2`, `address3`,
`address4`, `address5`, `address6`, `supptype`, `lat`, `lng`,
`currcode`, `suppliersince`, `paymentterms`, `lastpaid`,
`lastpaiddate`, `bankact`, `bankref`, `bankpartics`,
`remittance`, `taxgroupid`, `factorcompanyid`, `taxref`,
`phn`, `port`, `email`, `fax`, `telephone`, `url`,
`defaultshipper`, `defaultgl`
FROM suppliers WHERE supplierid='" . $oldCode . "'";