equal
deleted
inserted
replaced
22 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
22 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
23 <tr> |
23 <tr> |
24 <td>Produktgruppe</td> |
24 <td>Produktgruppe</td> |
25 <td><select name="vr[prodg]" <?php if ($rvnr == 1) echo "onchange=\"this.form.submit();\""; ?>> |
25 <td><select name="vr[prodg]" <?php if ($rvnr == 1) echo "onchange=\"this.form.submit();\""; ?>> |
26 <?php |
26 <?php |
27 if ($vr["prodg"] == -1) $select = " selected "; else $select = ""; |
27 if (is_array($_SESSION["prodg"])) |
28 echo "<option $select value=\"-1\"></option>\n"; |
28 { |
29 $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe ORDER BY 2"; |
29 foreach ($_SESSION["prodg"] as $val) |
|
30 $listg .= ",'" .$val . "'"; |
|
31 $listg = substr($listg,1); |
|
32 } |
|
33 else |
|
34 { |
|
35 if ($vr["prodg"] == -1) $select = " selected "; else $select = ""; |
|
36 echo "<option $select value=\"-1\"></option>\n"; |
|
37 } |
|
38 //Einschraenkung Produktgruppe |
|
39 if (isset($listg) && $listg) $wher = " WHERE prod_group_ID IN ($listg) "; else $wher = ""; |
|
40 $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe $wher ORDER BY 2"; |
30 if ($result = $dbc->queryObjectArray($sql)) |
41 if ($result = $dbc->queryObjectArray($sql)) |
31 { |
42 { |
32 $select = ""; |
43 $select = ""; |
33 foreach ($result as $row) |
44 foreach ($result as $row) |
34 { |
45 { |