Questions tagged as 'select'

Tagged questions
1
answer

Query with array returning only first record

I have the following querys: <?php $VarMensagem = 1; $pdo = new PDO($dsn, $un, $pwd, $opt); $data = array(); $dataGeral = array(); try { $stmt = $pdo->query("SELECT * FROM mensagem WHERE me...
asked by 14.03.2017 / 04:23
1
answer

Doubt with this query [closed]

My teacher did the following query to show the total quantity of stock of each product, however I did not quite understand how it does to generate the total inventory quantity of each product, follows the query: SELECT SUM (ret.quantidade) A...
asked by 02.12.2016 / 16:32
2
answers

Select in MySQL ignoring single quotes

Hello How can I use this select and ignore value with single quotes? . . .st.executeQuery("select * from tabela_A where id = uc"); rs = st.getResultSet(); while (rs.next()) { texto = rs.getString("rua")...
asked by 02.12.2016 / 17:34
1
answer

Table with select and submit

Hello friends I am trying to make a table, for each item in the table it appears a <select> and a submit that will send data via POST , as it is relative how many units will appear can not predict quantities. Unfortunat...
asked by 05.11.2016 / 21:56
1
answer

Unexpected Result in SELECT

I have a SELECT that joins three tables, taking the data from the request, requesting client, responsible assistant, and values related to the requests. all Clientes and Assistentes duplicates in this query are returning...
asked by 18.09.2016 / 15:50
1
answer

Open javascript with Select Option

I want to open openVit () and openVilla () when the select option is pressed. <select> <option href='javascript:;' onchange="abrirVit();" value="canto">Vitória - Praia do Canto</option> <option href='javascript:;' onchange...
asked by 19.09.2016 / 22:26
1
answer

Firebird - Select to join two or more rows

I have a table with the following structure: Cliente_id | credito | debito | pedido 1 100 1 1 150 1 1 30 1 2...
asked by 09.09.2016 / 21:20
1
answer

Add different columns in the same result

I'm trying to generate a SELECT in PostgreSQL that pulls columns from different tables into the same column as the result. Home Example: Usuario ----------------------- | id | nome | regra | |---------------------| | 1| João | ADM | |-...
asked by 22.07.2016 / 18:13
1
answer

How to do a 'select multiple' start with the first option already checked PHP Mysql

Here's my component: $query_menu = mysql_query("SELECT rm_id AS FUNCAO, rm_desc AS DESCRICAO, rm_obs AS OBSERVACAO, rm_status AS STATUS FROM radios_menu WHERE rm_statu...
asked by 18.07.2016 / 17:39
1
answer

Difference between texts with several paragraphs in Mysql

I have two fields in the table (text) that receive several lines (paragraphs) of information, for example: CAMPO1 linha1 linha2 linha4 linha5 CAMPO2 linha1 linha2 linha3 linha4 I need to check which line is missing by crossing the informat...
asked by 22.06.2016 / 17:23