Questions tagged as 'select'

Tagged questions
1
answer

C # - Display search results in DataGridView (SELECT SQL)

Hello! I'm starting effectively in C # and I already have small projects. I can already connect to the remote database, I can already execute queries, I just can not get the result of a Select and show in a DataGridView. Honestly, if there is a...
asked by 15.03.2016 / 22:33
1
answer

Receive select fill in jQuery

I made a table where each row has a select and a refresh button. The problem is that when I click on the refresh of a particular row I want to update only that row and therefore I need to receive by jQuery only the number that is in the select o...
asked by 13.01.2016 / 17:37
1
answer

Select multiple to avoid 2 queries to the database

I have the following select (using PDO): $usuariosListados = $pdo->prepare("SELECT user_1, user_2 FROM usuarios WHERE user_1 = '".$_SESSION["usuario"]."' AND estatus = 2"); $usuariosListados -> execute(); $fAll = $usuariosListados ->...
asked by 20.07.2015 / 23:35
2
answers

Call value from another page [closed]

Hello everyone. I'm having a problem with passing data from one page to another. I have already tried for session and not very sure and I will explain the reason: I have a news page that distributes them for a for $ arr [] where I embed the t...
asked by 17.09.2015 / 06:56
1
answer

MySQL Query - Trasnposition

I have the following query: SELECT despesa.codRequisicao, despesa.histDespesa, despesa.despesaPassagem, despesa.despesaTaxi, despesa.despesaHotel, despesa.despesaRefeicao, despesa.despesaOutros FROM...
asked by 22.10.2014 / 13:32
1
answer

Select saves the same data in 2 different fields

I need to know that when the employee selects the product the "product code" is automatically populated, so far so good, but when I write the data in the DB, the product and product_code have the same data (in this case the product code)....
asked by 09.09.2014 / 15:00
1
answer

Java check, display the values registered in the MySQL database

I need help I'm doing a game in java and I need all the records and files and etc of the players in my table but I can not connect to the database much less check and display the values Ps: the Sun.java tutorial from DriverConnector did not h...
asked by 25.07.2014 / 14:13
1
answer

Change the select when the input is filled [closed]

Ifthe"PANTONE" input field is filled in, the "LINEAT" field is automatically set to "52". In PHP or JS     
asked by 22.10.2018 / 12:43
1
answer

How to merge different tables with Select [closed]

I have 3 tables Animal - (ID, Description, Code) AnimalRacao - (ID, Animal_id, Racao_id, Quantity) Racao - (ID, Description, Value) An animal can have several rations. I would like to make a select that shows me the description of the a...
asked by 22.10.2018 / 22:10
1
answer

Join in three tables does not show all results

SELECT * FROM produto_unidades join produto_notas on produto_notas.id = produto_unidades.produtoNota_id join produto_licitacoes on produto_licitacoes.id = produto_notas.produtoLicitacoes_id where produto_unidades.unidade_id = 2 The join work...
asked by 22.10.2018 / 19:44