equal
deleted
inserted
replaced
20 echo "<tr><td>Produkt-Gruppe: </td><td>" . $row->prod_group_name . "</td></tr>\n"; |
20 echo "<tr><td>Produkt-Gruppe: </td><td>" . $row->prod_group_name . "</td></tr>\n"; |
21 echo "<tr><td>Produkt-Bereich: </td><td>" . $row->prod_ber_name . "<td></td></tr>\n"; |
21 echo "<tr><td>Produkt-Bereich: </td><td>" . $row->prod_ber_name . "<td></td></tr>\n"; |
22 } |
22 } |
23 echo "<tr><td>Produkt-Hierarchie: </td><td>" . $phier . "<td></td></tr>\n"; |
23 echo "<tr><td>Produkt-Hierarchie: </td><td>" . $phier . "<td></td></tr>\n"; |
24 // Arbeitsgruppe |
24 // Arbeitsgruppe |
25 $sql = "SELECT ag_ID, ag_name, abt_name FROM Arbeitsgruppe g INNER JOIN Abteilung a |
25 $sql = "SELECT rag_ID, rag_bez, abt_name FROM RaumArb_Gruppe g INNER JOIN Abteilung a |
26 ON g.abt_ID = a.abt_ID |
26 ON g.abt_ID = a.abt_ID |
27 WHERE ag_ID = '" . $prod["ag"] ."' "; |
27 WHERE rag_ID = '" . $prod["ag"] ."' "; |
28 if ($result = $dbc->queryObjectArray($sql)) |
28 if ($result = $dbc->queryObjectArray($sql)) |
29 { |
29 { |
30 foreach ($result as $row) |
30 foreach ($result as $row) |
31 echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->ag_name . "</td></tr>\n"; |
31 echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->rag_bez . "</td></tr>\n"; |
32 } |
32 } |
33 // Wichtigkeit |
33 // Wichtigkeit |
34 $sql = "SELECT imp_ID, imp_name_s FROM Wichtigkeit WHERE imp_ID = " . $prod["imp"]; |
34 $sql = "SELECT imp_ID, imp_name_s FROM Wichtigkeit WHERE imp_ID = " . $prod["imp"]; |
35 if ($result = $dbc->queryObjectArray($sql)) |
35 if ($result = $dbc->queryObjectArray($sql)) |
36 { |
36 { |