$harr = new MysqlHieroglyphics(); $sql = "SELECT hid, hink FROM Hieroglyphics WHERE hink LIKE '%{$oldroot},%'"; $myarr = $harr->query($sql); foreach ($myarr as $row) { $hid = $row['hid']; print MysqlHieroglyphics::htm_img($hid); print "<a>==</a>"; $orglnk = $row['hink']; print MysqlHieroglyphics::htm_img($orglnk); print "<br>"; $newlnk = MysqlHieroglyphics::replace_root_of_links($oldroot, $newroot, $orglnk); //preg_replace("/$oldroot/i", $newroot, $orglnk); print $newlnk . "<br>"; print MysqlHieroglyphics::htm_img($hid); print "<a>==</a>"; print MysqlHieroglyphics::htm_img($newlnk); print "<br>"; if (isset($_REQUEST["confirm"]) && $_REQUEST["confirm"] == "on") { $sql = "UPDATE Hieroglyphics SET hink='{$newlnk}' WHERE hink='{$orglnk}'"; print "<a>{$sql}</a><br>"; $myarr = $harr->execute($sql); } else { print "confirm is not set to 1. no db changes.<br>"; } print "<br><br><br>"; } print "<br>"; $_REQUEST["oldroot"] = null; $_REQUEST["newroot"] = null; $_REQUEST["confirm"] = null; //print_r($myarr);