Questions tagged as 'select'

Tagged questions
1
answer

Dynamically load content using the select tag

I have a question and I wish you could help me. My case is the following I have a dynamic where according to the selected option it returns a JSON with the information of the Hotels Units. What I need is to populate the JSON content in HTML a...
asked by 11.05.2016 / 20:56
2
answers

Check checkboxes when choosing value from a DB in PHP (Laravel)

I have a problem that I do not know how to solve and I do not know how to search. I'm building a system in php - laravel . This system will have user levels. I've done all of the sign-ups, changes, user views, groups, and permissions. H...
asked by 29.04.2016 / 17:11
2
answers

Select empty data

My code returns all users, verifying that they have paid the last month, however I connect two tables, one of all the clients with the registered payment table, I want it to print in jTable even if it does not have left join seems...
asked by 27.04.2016 / 18:21
1
answer

Select multiple Mysql

I need to fetch data from a table and complete it with data from another table ... Main table: agendatelefone Secondary table: neighborhood principal: [{"id":1,"tipo":"delivery","nome":"aaa","telefone":983585042,"endereco":"26 de outub...
asked by 09.03.2016 / 19:11
1
answer

How to make a SQL do the correct count of real estate under certain criteria

I have the following SQL that correctly counts the number of properties: select clientes.id, clientes.nome, clientes.status, clientes.cliente, clientes.tipo, clientes.disponibilidade, imoveis.id, imoveis.cod, imoveis.status, imoveis.vvenda,...
asked by 16.03.2016 / 12:41
0
answers

Query with sql does not return when using WHERE

I have a query that should bring the name of the users who received a message sent by a user: SELECT msg.msg_content ,usr.user_name FROM message AS msg INNER JOIN usuarios AS usr ON msg.user_id_out = usr.user_ssid WHERE usr.user_...
asked by 24.02.2016 / 17:26
0
answers

Traverse all strings by delimiter in the field and generate a column with the result

SET @contador := 0; SELECT SUBSTRING_INDEX( SUBSTRING_INDEX("BOX 01;BOX 02;BOX 03;BOX 04;BOX 05;BOX 06;BOX 07;BOX 08;BOX 09;BOX 10;BOX 11;BOX 12;BOX 13;BOX 14;BOX 15;BOX 16;BOX 17;BOX 18;BOX 19;BOX 20;BOX 21;BOX 22;BOX 23;BOX 24;BOX 25;B...
asked by 25.02.2016 / 17:09
1
answer

create view php / oracle

I want to generate a view through php for an oracle database where the select is done through the result of another query. This query mounts the select to the view: $sql1 = "SELECT TESTE FROM VIEW_TESTE"; $result1 = odbc_exec($conOraSql , $...
asked by 25.11.2015 / 18:06
2
answers

I can not do update because it is not retrieving the id php pdo

Here is to recover in html : if(isset($_GET["id"])){ $administrador = new Administrador(); $mostrar = $administrador->listar_id($_GET["id"]); } <form action="Crud.php" method="post" id="none">...
asked by 21.12.2015 / 13:52
0
answers

Selecting sets of JPA values

I have the following problem: I have a table with a list of values for a composite key. Here's an example: ID | ItemCode | Localidade | Preco ---+----------+------------+------- 01 | 001 | 001 | 3.5 02 | 002 | 001...
asked by 26.10.2015 / 19:09