/* vim: set ts=4 sw=4 et : */ require_once __DIR__ . "/check_auth.php"; require_once __DIR__ . "/../includes/common.php"; require_once __DIR__ . "/lookup.php"; require_once __DIR__ . "/lookup_more.php"; (function () use ($mysqli) { global $orgaID, $superorgaID; $sql = " SELECT Organisationen.ID AS ID, Organisationen.Name, Organisationen.strasse, Organisationen.plz, Organisationen.ort, Organisationen.adresszusatz, Superorga.Name AS Superorganisation, Superorga.ID AS SuperID FROM Organisationen LEFT JOIN Organisationen AS Superorga ON Organisationen.Superorganisation = Superorga.ID WHERE Organisationen.ID=? "; $stmt = $mysqli->prepare($sql); $stmt->bind_param('i', $_GET['id']); $stmt->execute(); $r = $stmt->get_result(); $l = $r->fetch_object(); $orgaID = $l->ID; $superorgaID = $l->SuperorgaID; $_title = 'Organisation: ' . $l->Name . ' (ID '. $_GET['id'] . ')'; include_once __DIR__ . "/header.php"; ?>