<?php require 'conexao/funcao.inc.php'; require 'conexao/config.php'; require 'conexao/conn.php'; require 'conexao/function.php'; $estado = $_POST['estado']; ?> <label>Contato: </label> <select name="setoressetor" class="form-control chosen-select888" id="contato" > <option value="">Selecione o contato</option> <?php $query = "SELECT * FROM cw_setor, cw_setores WHERE id_setor=setor_setores AND cliente_setor='$estado'"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){?> <option value="<?php echo $ln['id_setor']; ?>"><?php echo $ln['nome_setor']; ?> | <?php echo $ln['nome_setores']; ?></option> <?php } ?> </select>