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); } }