db = $db; } function showInputField($fk_product) { $inputFieldString = ''; $sql = "SELECT pr.rowid, pr.label FROM llx_product as pr INNER JOIN llx_product_extrafields as pre ON pre.fk_object = pr.rowid WHERE pre.is_in_bundle IS null AND pre.hotelsales is null ORDER BY pr.label"; $result = $this->db->query($sql); $inputFieldString .= ''; $inputFieldString .= ' '; if ($this->db->num_rows($result) > 0) { while ($row = $this->db->fetch_object($result)) { $selected = $row->rowid == $fk_product ? 'selected' : ''; $inputFieldString .= '' . $row->label . ''; } } $inputFieldString .= ''; return $inputFieldString; } } ?>