movenote.php

<?php
$sqlpath = $_SERVER['DOCUMENT_ROOT'];
$sqlpath .= "/sql-connect.php";
include_once($sqlpath);

$id = $_REQUEST['moveID']; // 138
$movelineage = $_REQUEST['moveLineage']; // 122 or ''
$sql = "SELECT id, lineage FROM notes WHERE lineage LIKE '%-$id-%' OR lineage LIKE '$id-%' OR lineage LIKE '%-$id' OR lineage LIKE '$id'";
$sqldata = mysqli_query($dbcon, $sql) or die('error getting data');

while($row = mysqli_fetch_array($sqldata, MYSQLI_ASSOC)) {
    $tempid = $row['id']; // 138
    $oldlineage = $row['lineage']; // 23-138
    $oldlineage = strstr($oldlineage, $id); // 138

    // Trim leading hyphen if present
    $oldlineage = ltrim($oldlineage, '-');

    // Construct newlineage based on movelineage
    if ($movelineage == '') {
        $newlineage = $oldlineage;
    } else {
        $newlineage = $movelineage . '-' . $oldlineage;
    }

    $sql1 = "UPDATE notes SET lineage='$newlineage' WHERE id LIKE '$tempid'";
    if ($dbcon->query($sql1) === TRUE) {
        echo $id;
    }
}
?>