Questions tagged as 'select'

Tagged questions
0
answers

Hide results minus the selected SELECT

Good the other day a colleague from here helped me to show in a select the references that there are of a product in a select and those available and those that came from other references to hide them. (This is editing a record) All this is w...
asked by 18.09.2018 / 09:02
2
answers

Input shows the result on three selects

Good morning I'm doing the insertion of orders and I need some help. The idea is that according to two selects the result has to come out in an input. On the one hand we have the producto that is in the table productos +----+-...
asked by 13.09.2018 / 08:52
1
answer

Select from 3 tables mysql

I have a query that already brings information from 2 tables, but I need to add to the statement that brings me information from the table called locales to bring the name of the place that is identified with id from the table equipos...
asked by 23.08.2018 / 11:31
2
answers

how to work update several select with ajax

I am loading the contents of several select with ajax, everything works fine when I execute one by one, but when nesting it executes the ajax but does not take the refreshed value, that is, I have three select and I wish that when executing the...
asked by 29.08.2018 / 01:02
1
answer

How does a column of dates compare to a specific date?

In this image on the left side are the tables that give me, on the side right is what he asks me to do and below in blue is the code that I made in MySQL database language do not know what statement should be used to be able to select...
asked by 17.08.2018 / 06:23
0
answers

Update a table when changing a select with data displayed by a while, php

My problem is that I have a table of products and the number of pieces chosen, but I have the option that the pieces are changed by a select and consequently the subtotal is changed, and the total of all the buy, but it only works with th...
asked by 13.08.2018 / 16:22
1
answer

Myslqi query of two tables with sum of records

Good to have if I can explain everything; I have two tables in the BD: productos +----+----------+--------+ | id | producto | estado | +----+----------+--------+ | | | | | | | | +----+----------+...
asked by 20.08.2018 / 09:08
1
answer

Collect the value of GET in a Select and leave selected the correct value

I need to pass the value that I receive from a get to a Select and that the value I receive is selected. So far I've done that, but I only get the option selected by the GET, it does not show me the rest of the options. I show my code in case yo...
asked by 09.08.2018 / 09:51
0
answers

SELECT query * FROM Does not bring all the data

I'm doing a query from one excel file to another. Through a recordset with the method SELECT I bring the columns that I want to my base, the problem is that I have a column Date de Facture with data type DATE (04/01/2018)...
asked by 09.08.2018 / 12:43
1
answer

SELECT ANIDADOS

I make a ticket system in which when filling out my form of my main table tickets I have users and areas what I intend to do in my form > select is that when choosing an area, only the users that belong to that area appear . I appreciate...
asked by 01.08.2018 / 08:00