<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 07/2011

 * 

 * Anlisten Produkt - INSERT/UPDATE-Daten

 */

            echo "<table>\n";

            echo "<tr><td>Produkt-ID: </td><td>" . $prod['pnr'] . "<td></td></tr>\n";

            echo "<tr><td>Produkt-Name: </td><td>" . $prod['pname'] . "<td></td></tr>\n";

            // Produkt-Gruppe, Bereich

            $sql = "SELECT prod_group_ID, prod_group_name, prod_ber_name FROM Produkt_Gruppe g 

                        INNER JOIN Produkt_Bereich b ON g.prod_ber_ID=b.prod_ber_ID

                        WHERE prod_group_ID = " . $prod['grp'];

            if ($result = $dbc->queryObjectArray($sql))

            {

                foreach ($result as $row)

                echo "<tr><td>Produkt-Gruppe: </td><td>" . $row->prod_group_name . "</td></tr>\n";

                echo "<tr><td>Produkt-Bereich: </td><td>" . $row->prod_ber_name . "<td></td></tr>\n";

            }

            echo "<tr><td>Produkt-Hierarchie: </td><td>" . $phier . "<td></td></tr>\n";

            // Arbeitsgruppe

            $sql = "SELECT ag_ID, ag_name, abt_name FROM Arbeitsgruppe g INNER JOIN Abteilung a 

                        ON g.abt_ID = a.abt_ID

                        WHERE ag_ID = '" . $prod["ag"] ."' ";

            if ($result = $dbc->queryObjectArray($sql))

            {

                foreach ($result as $row)

                echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->ag_name . "</td></tr>\n";

            }

            // Wichtigkeit

            $sql = "SELECT imp_ID, imp_name_s FROM Wichtigkeit WHERE imp_ID = " . $prod["imp"];

            if ($result = $dbc->queryObjectArray($sql))

            {

                foreach ($result as $row)

                echo "<tr><td>Wichtigkeit: </td><td>" . $row->imp_name_s . "</td></tr>\n";

            }

            // Bindungsstaerke

            $sql = "SELECT conn_ID, conn_name_s FROM Bindungsstaerke WHERE conn_ID = " . $prod["conn"];

            if ($result = $dbc->queryObjectArray($sql))

            {

                foreach ($result as $row)

                echo "<tr><td>Bindungsst&auml;rke: </td><td>" . $row->conn_name_s . "</td></tr>\n";

            }

            echo "<tr><td>Bemerkung: </td><td>" . $prod['pbem'] . "<td></td></tr>\n";

            echo "</table>\n";

?>