<?php
include_once ("../lib/common.inc.php");
$query = 'SELECT "CNID","parentCN","amendmentReason" FROM contractnotice WHERE
"parentCN" > 0 ';
$query = $conn->prepare($query);
        $query->execute();
        if (!$query) {
                databaseError($conn->errorInfo());
        }
foreach ($query->fetchAll() as $row) {
  $conn->exec('UPDATE contractnotice SET childCN = "' .
                         $row['CNID'] . '", amendmentReason = "' .
                         $row['amendmentReason'] . '" where "CNID" = "' .
                         $row['parentCN'] . '";');
    $errors = $conn->errorInfo();
              
              if ($errors[1] == 7 || $errors[1] ==0)
                  echo $row['CNID'] . " linked to parent " . $row['parentCN'] .
  "<br>\n";
  else print_r($errors);
 
}
?>