<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 05/2013
 * 
 * Anlisten INSERT/UPDATE Daten Keytyp
 */

            echo "<table>\n";
            echo "<tr><td>Schl&uuml;sseltyp: </td><td>" . $ky["typ"] . "</td></tr>\n";
            echo "<tr><td>Level: </td><td>" . $ky["level"] . "</td></tr>\n";
            echo "<tr><td>Parent-Level: </td><td>" . $ky["parent"] . "</td></tr>\n";
            if ($ky["hier"])
            {
                $sql = "SELECT key_hiertyp_bez FROM Key_Hiertyp WHERE key_hiertyp_ID ='" . $ky["hier"] ."'";
                $hier = $dbc -> querySingleItem($sql);
                echo "<tr><td>Hierarchietyp: </td><td>" . $ky["hier"] . " - $hier</td></tr>\n";
            }
            else echo "<tr><td>Hierarchietyp: </td><td>&nbsp;</td></tr>\n";
            echo "<tr><td>Bezeichnung: </td><td>" . $ky["bez"] . "</td></tr>\n";
            if ($ky["anl"])
            {
                $sql = "SELECT key_anl_bez FROM Key_Anlage WHERE key_anl_ID = ".$ky["anl"];
                $anl = $dbc -> querySingleItem($sql);
                echo "<tr><td>Schlie&szlig;anlage: </td><td>$anl</td></tr>\n";
            }
            else echo "<tr><td>Schlie&szlig;anlage: </td><td>&nbsp;</td></tr>\n";
            echo "</table>\n";            
?>