Questions tagged as 'select'

Tagged questions
2
answers

Fill inputs dynamically after change in select

Good afternoon, I need help with some of the code. Basically I have a form with two selects ( aluno_id, producto_id ) and some inputs ( product_preco, quantity, preco_total ), use functions to fill arrays and then selects by ID and display By th...
asked by 13.11.2017 / 19:57
0
answers

Separate MySql result in blocks in PHP

I have a real estate table divided into several categories and I want to list them on my PHP page. The detail is that I wish that in one region of the page are listed the houses, in another the apartments and so on. In other situations I did a s...
asked by 06.11.2017 / 18:36
0
answers

How to perform a SELECT DISTINCT - H2

I need to make a SELECT DISTINCT in the database H2 but in the way I'm doing it is not returning me anything: SELECT DISTINCT lote FROM LotesEncerrados l ORDER BY l.lote ASC I did the same thing on PostgreSQL and it w...
asked by 06.11.2017 / 14:29
0
answers

SQL does not return all records in the table

My application consists of an html page in which the user informs the code of a product, the quantity, and it is shown below. Behold, if I add a product, it is inserted, but it does not return. And when I continue to add items, only the followin...
asked by 11.10.2017 / 03:21
0
answers

Make two or more Select with Aliases in the query to generate a separate array

I have a single table of only one column with all the words in Portuguese. I want to make a Double or Triple Select and retrieve in every query all words with 'A' in the alias WordsComA, and all with 'B' in the Alias WordsComB. When I recover...
asked by 23.09.2017 / 01:31
1
answer

How to give select between one hour_minute and another in SQL

I need to resolve a simple exercise requesting to report the amount of books sold between 1:00 pm and 5:30 pm on all dates. I was able to pull between 13h and 17h but not with the "17h30" minutes. I did so: SELECT SUM(quantidade) FROM n...
asked by 10.09.2017 / 06:06
1
answer

I do not receive data from SELECT FROM

I'm doing a simple login system but I never get a real line where $sql = "SELECT * FROM $this->table WHERE 'email' = :email AND 'senha' = :senha"; But the email and password are correct, PHP Function: public function logarUsuario(){...
asked by 19.08.2017 / 20:29
1
answer

MS ACCESS Subselect "At most one record can be returned by this subquery."

asked by 02.08.2017 / 17:18
1
answer

Select connecting 3 tables in Firebird with different IDs

Good afternoon, I need to make a select that returns the description of the product, barcode and price . The description and price are in one table (TB_ESTOQUE) and the barcode is in another (TB_EST_PRODUCT). However, the IDs of th...
asked by 07.07.2017 / 21:48
0
answers

Select in two fields of a table

Hello, I'm having a problem and I'd like to ask for help from you. It is as follows: I'm integrating a PHP system into the Wordpress Woocommerce plugin and I need to order some products from the database, so far so good. The problem starts wh...
asked by 05.07.2017 / 19:43