function getParent()
{
global $area, $db;
echo "<option value=''>New Parent</option>";
try {
$parentQuery = $db->prepare("SELECT * FROM `link` WHERE parent IS NULL AND `area` = :area AND `visible` = 1");
$parentQuery->execute(array(':area' => $area));
} catch (PDOException $e) {
exit("error in query");
}
while ($row = $parentQuery->fetch(PDO::FETCH_ASSOC)) {
echo "<option value=" . $row['index'] . ">" . $row['name'] . "</option>";
getSubParent($row['index']);
}
}
function getParent($current, $parent)
{
global $area, $db;
echo "<option value='NULL'>New Parent</option>";
try {
$linkQuery = $db->prepare("SELECT * FROM `link` WHERE `index` != :current AND `parent` IS NULL AND `area` = :area");
$linkQuery->execute(array(':current' => $current, ':area' => $area));
} catch (PDOException $e) {
exit("error in query");
}
while ($row = $linkQuery->fetch(PDO::FETCH_ASSOC)) {
if ($row['index'] == $parent) {
echo "<option value=" . $row['index'] . " selected>" . $row['name'] . "</option>";
} else {
echo "<option value=" . $row['index'] . ">" . $row['name'] . "</option>";
}
getSubParent($current, $row['index'], $parent);
}
}
