Questions tagged as 'select'

Tagged questions
1
answer

Merge results from two tables

I need to make a SELECT into two tables and merge the results. My tables are "class_tracks" and "progress_tracks". In the table "courses_aula" I have all the classes of a course. In the table "cursos_progresso" I have registration only...
asked by 14.12.2016 / 18:47
1
answer

How to pass the value of a "$ variable" from another page, and use it in a select PDO

Next, first I would like to know if it is possible to receive a value from a variable from another page, by session_start() , and apply it to a select. I'm doing it this way: At the top of the page where I want to add select, I've ad...
asked by 30.11.2016 / 14:38
1
answer

How to create a sub-select in oracle in a table with composite key?

The table has composite primary key, and the fields are a date (ID_DEPURACAO) and a number (SEQ_DEPURACAO). What I want to do is a sub-select that takes only data that is larger than a certain date and has sequences from a certain number....
asked by 28.10.2016 / 13:44
1
answer

How to execute a php command dynamically during program execution

I'm doing a web application that displays a cam stream, however whenever I use it, it's necessary to reload the page, and I need it to happen automatically. My idea is to dynamically run a query in the database using php , for the refresh p...
asked by 03.11.2016 / 22:30
1
answer

Build Dynamic Playlist With Select Option

I want to create multiple "Play List" using a select element, instead of leaving it in the body of the HTML document , I want to put it in an "js" , and call each "Play List" through a "Search field" where you must type the corresponding...
asked by 27.09.2016 / 16:46
0
answers

Error Column count does not match value count at row 1, for a select

My system, in the save button, I inserted 3 tables at the same time, 2 using FK, I'm using the cad_id field as FK in 2 tables, I'm doing a select to pick up a single cad_id field to save in the bank other 2 tables, using the resultset, to set an...
asked by 17.09.2016 / 20:55
1
answer

Select manual in repository using Spring?

Hello, I would like to know if there is a way to do a select within Repository , I am using Spring and REST , I need to return all entities that have another entity, I would get them by id, and I need to feed a call ajax with i...
asked by 17.08.2016 / 15:48
1
answer

How to select a table row and display information in another table relative to the table?

I am using this code but I am not able to interconnect them as it should be ... I wanted to register Payments (payments) so these only appear when you have to select the partner in the (partner) table ... String sql = "SELECT socio.*,...
asked by 01.07.2016 / 02:28
0
answers

Make SELECT display a certain value of a column last, keeping ordering by another column

I'm doing the following select in a database and displaying the result in a table in php: SELECT ID_PRDC, PRDC_ID_PRDT, PRDC_ID_SEM, DATA_PRDC, LINHA.NM_LN, PRODUTO.NM_PRDT, SEMI_ACABADO, NUM_OP, LOTE, QTD, PRDC_NUM_SEQ_LN, SITUACAO.DE...
asked by 22.07.2016 / 14:10
0
answers

How to register, query and display data on the same request?

I have a form where the user inserts his data (name, experience, height and weight), the information is registered in the bank, compared and is returned to the user the ideal board model according to his information, within a modal . All t...
asked by 17.06.2016 / 17:35