Questions tagged as 'select'

Tagged questions
1
answer

Interaction and filling of fields with 2 select

I'm doing a fill-in form with two selections, but I want the second option to come up depending on the result of what I've selected in the first one, so it's going to be: <div class="form-group"> <label>Categoria: </label>...
asked by 17.07.2018 / 02:34
0
answers

Select IN SQL in Linq or EntityFramework

in a system I get a list like that l_res2 = contexto.Ventas.Where(x => in_obj.FechaFin >= x.FechaInicio && in_obj.FechaInicio <= x.FechaFin ).OrderBy(x => x.FechaFin).ToList(); Now, I have a table Sales_States IdSaleId...
asked by 04.07.2018 / 19:22
0
answers

Pass a query in a datatable to a modal

I want to visualize a detail of a datatable in a modal window from a datatable of a starting page but I can not visualize the output error. The code: $query ="SELECT * FROM caja ORDER BY id DESC"; $result = mysqli_query($connect, $query);...
asked by 09.07.2018 / 00:32
1
answer

Query with many fields and records in MySQL

Good afternoon forum STACKOVERFLOW , I hope you can support me with a MySQL query I have a table of 72 columns and 64 records. The table so requires my boss for questions of standardization. The base has only in the registers the number 1...
asked by 20.06.2018 / 19:10
0
answers

php form with mysql, I can only capture a select value in the list

I have a problem with showing some data in a select button, it happens that by default it always shows me the first one in the row, I made the test by entering different values in the database, it takes me but not listing it. When entering a new...
asked by 22.06.2018 / 02:27
0
answers

query or cursor mysql

I have a problem with this type of query or it would be better with a cursor I leave you an example table: *create table table11( cod_table int, dni varchar(9), doc_slug varchar(100), doc_tipo int, fecha_vecimiento date, fecha_carga date )...
asked by 13.06.2018 / 22:50
0
answers

Doubt ORDER BY with INNER JOIN

Hi, I want to generate a classification of some equipment but I do not know how to do it so that they come out in a specified order, I do not know how to enter the ORDER BY. SELECT divisiones.id_eq1 AS Equipo_1, eq1.name_eq AS Nomb...
asked by 06.06.2018 / 11:39
0
answers

Select conditioned MySQL WOrkbench

How about, I have the following table: These data I have entered for the moment: Where you can see that I have the subjects of the students, I need to take out the semester in which each student goes, because in this table he s...
asked by 30.05.2018 / 22:57
1
answer

Select and insert php data

Guys, I doubt this data // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = " Select a.fe...
asked by 28.05.2018 / 23:06
0
answers

Error making query in php, postgresql Database error: Error 989 Session Halted

I am currently working with a php system, when I click on the link to see detailed information on the table, I get the following error: Database error: Invalid SQL: SELECT * FROM tabla WHERE campo = '' Error989 Session halted. I'...
asked by 25.05.2018 / 17:10