Questions tagged as 'select'

Tagged questions
1
answer

Select with users who most sent messages

I'm making a system and I have to know which user sent the most messages. My tables look something like this: User id|nome|sobrenome|email| ... Messages id|uid|nome|email|assunto|msg| ... I just need to know which user sent more...
asked by 12.08.2017 / 21:56
2
answers

Database not returning any value

I have the following code: $sql="SELECT * FROM imoveis WHERE (suite LIKE '%".$suites."%' OR banheiro LIKE '%".$banheiro."%' OR quarto LIKE '%".$quarto."%' OR garagem LIKE '%".$garagens."%')...
asked by 11.12.2018 / 00:00
1
answer

Doubt to count records in a MySQL database query

In a MySQL database, I have two columns of type varchar that brings me records in this format: ["165","184","192","209","242"] One more example: Each number in double quotation marks is a record, that is, it is the ID of some stude...
asked by 25.09.2018 / 20:42
1
answer

Make a select with 3 tables and return in table 3 the records of the id of the first [duplicate]

I have 3 tables, the first is occurrence, second is the individuals and third vehicles. The tables individuals and vehicles I made subforms of occurrences. I have the first key in the instance id_current, the other tables I have the primary ke...
asked by 07.05.2018 / 22:22
4
answers

Select option selected

I need to leave the selected option selected according to the field recorded in mysql. The form is to edit pos so it displays the available fields with the foreach. Ex: <select name="segurado" > <option value=""></optio...
asked by 11.08.2017 / 11:29
2
answers

select name in bank with C #

I'm developing an application in C # windows form in 3 layers. My problem is: I have datagridview to receive the database data and a textbox to be typed the name I want to fetch in the database, but as I'm doing it in 3 layers I'm...
asked by 01.06.2017 / 00:20
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
1
answer

Change content according to select option

Someone could help me in how I can change the information that is in blue in the image below, according to select selection (monthly, quarterly, semiannual and annual). I need to change the value of the product and the button link:...
asked by 05.07.2017 / 17:09
1
answer

How to do a mysql query from a link

I have seen in some sites links that make mysql searches and return results, ie, make a mysql query from a link instead of a field. Assuming the link within the tag to is like this: href="https://www.meulink.com" name="camisas" >Camisa...
asked by 15.06.2016 / 17:55
1
answer

I need help with PHP language

So I'm having trouble with a part of my code, as it's too big I'll post only the part that is in error: <?php try{ $entrar = $_POST["entrar"]; $cpf = $_POST["cpf"]; $senha = $_POST["senha"]; /*Conexão com o banco de dados...
asked by 31.08.2018 / 16:18