$sql = "INSERT INTO debtorsmaster (`debtorno`,
`name`,
`address1`,
`address2`,
`address3`,
`address4`,
`address5`,
`address6`,
`currcode`,
`salestype`,
`clientsince`,
`holdreason`,
`paymentterms`,
`discount`,
`discountcode`,
`pymtdiscount`,
`lastpaid`,
`lastpaiddate`,
`creditlimit`,
`invaddrbranch`,
`ediinvoices`,
`ediorders`,
`edireference`,
`editransport`,
`ediaddress`,
`ediserveruser`,
`ediserverpwd`,
`taxrref`,
`customerpoline`,
`languageid`,
`typeid`)
SELECT '" . $_POST['NewDebtorNo'] . "',
`name`,
`address1`,
`address2`,
`address3`,
`address4`,
`address5`,
`address6`,
`currcode`,
`salestype`,
`clientsince`,
`holdreason`,
`paymentterms`,
`discount`,
`discountcode`,
`pymtdiscount`,
`lastpaid`,
`lastpaiddate`,
`creditlimit`,
`invaddrbranch`,
`ediinvoices`,
`ediorders`,
`edireference`,
`editransport`,
`ediaddress`,
`ediserveruser`,
`ediserverpwd`,
`taxrref`,
`customerpoline`,
`languageid`,
`typeid`
FROM debtorsmaster
WHERE debtorno='" . $_POST['OldDebtorNo'] . "'";