Questions tagged as 'select'

1
answer

How do I get the value of a record selected by combobox using php [closed]

If anyone has an answer, I will thank them very much. I want to get the value of the selected record to show it in the same form from where I select the record. This is my code: <tr> <td scope="row" align="right">Nombre de Ca...
asked by 28.06.2018 / 18:01
1
answer

LINQ query collects the values in keyValuePair object but then I can not save them all in the list

The following query LINQ takes all the parameters and all the stations and uses them to create a string and also stores them in a list of key pairs / value idestacion / parameter. To avoid confusion I have to clarify that this row: from x in...
asked by 12.06.2018 / 14:23
1
answer

Select between several tables MYSQL WORKBENCH

How about, My question is, I have several tables, which I show below where I highlight the relevant data for the query. I want to ask a question, where do I get the number of students per semester of each Program. Something like this...
asked by 24.05.2018 / 02:52
1
answer

What do you recommend to do this type of nested selects? [closed]

I'm designing a pretty complex form, with enough sql queries inside. I need to create many nested selects. The case, I currently use "onchange .. this form submit" .. To send by POST the information from one to another. The case, that I...
asked by 11.05.2018 / 18:55
1
answer

how to insert the value of a select into multiple columns of a table in MYSQL PHP

good day, I hope you can support me with this query, How can I insert the value of a select (combobox) php in multiple columns in a table in mysql depending on the selected data? . For example I have this form linked to nested combobox with...
asked by 14.05.2018 / 17:41
2
answers

Codeigniter3 - Get data from a controller by sending an id with ajax

I have been reviewing the site and I have not been able to find an answer to my question. I'm trying from a select with a list of products that I have in a view that when I select one I get updated the existence data of that product that I get f...
asked by 22.03.2018 / 19:54
1
answer

Dynamic Select with Javascript + jQuery with a Trello API request

I am making a request to the Trello API asking for some boards, I am currently showing those boards in a list in my HTML, but my intention is to show them in a select and I do not know how to do it, this is the way in which I'm doing. My HTML co...
asked by 15.03.2018 / 18:38
1
answer

Queries with My SQL

I have a SQL query that I can not solve: Structure of the tables used:    User table id pk uq ai nn nombre varchar(25) null apellido varchar(25) null    Position table id pk uq ai nn cargo varchar(50) null departamento varchar(50)...
asked by 23.12.2017 / 05:18
1
answer

Check the records of a field in SQL SERVER 2008

I need to know the number of records a field has in SQL SERVER 2008. If I execute the statement: select count(*) from 'tabla' the result that throws me is 996.561 but if I execute the sentence: select count(e-mail) from 'tabla' the...
asked by 04.12.2017 / 22:57
1
answer

I need to capture the data of the select to do a mysql query with them and show the result in a table

<?php include_once 'rutas.php'; $host = "localhost"; $user = "root"; $pass = ""; $bd = "freire"; $con = mysqli_connect($host, $user, '', $bd) or...
asked by 10.11.2017 / 23:31