Questions tagged as 'select'

1
answer

Select some data from different tables

Rebuilding the programmer here, I'm having trouble with SQL and I'm asking for help. I have two tables called orcamentos and clientes . I need to select all fields from the orcamentos table and only the nome...
asked by 05.04.2017 / 13:37
1
answer

Select from different tables [closed]

How to do a select from different tables? Type, check if there is value in one, if not, check the other.     
asked by 09.04.2017 / 20:46
2
answers

how to use the case with a select coming from html

Good morning, I need to pull data from the database, but wanted the user to choose from which data what value to search. My code html : <head> <title></title> </head> <body> <form method="POST"...
asked by 24.02.2017 / 14:16
2
answers

How to update select with jQuery

Hello. Home I have a select <div class="seletor"> <select name="numeros" id="numeros"> <option value="1" selected="selected">1</option> <option value="2">2</option> <option value="3"&...
asked by 22.05.2017 / 22:16
1
answer

Select deleted a record and searching for others with the same code [closed]

The product code I pass into the sql via php. For example $ cd_product = 2; I would like to list everything but the record for this product (cd_product! = 2). So far so good. But I would just like the records of the table (product_table...
asked by 27.01.2017 / 17:24
1
answer

Can you improve these 12 selections where only one parameter changes?

I have an online table with about 3 thousand records. I make twelve selects to list the results per month, eg: select count(campo) from tabela where extract(year from data) = 2016 and extract(month from data) = 1; select count(campo) from tabe...
asked by 26.10.2016 / 19:16
2
answers

Events with the tag selectoption

I'm trying to make a page with html + javascript, but I do not know anything about php ... Anyway, my doubt is this! I have created a checkbox, and when the user selects that option, I want to change a text ... But I can not identify which optio...
asked by 05.11.2016 / 17:49
1
answer

Select in mysql from this index

I am doing a query in the database and have to return the table from such index. for example: | ind | value | 001 | AAA | 002 | BBB | | 003 | CCC | 004 | DDD | 005 | EEE | | 006 | FFF | | 007 | GGG | 008 | HHH | I would have to ret...
asked by 22.10.2016 / 05:02
2
answers

SQL Select Where

Personal help please, I need to make a select in a table that contains ID, VALUE, DATE, NAME. The result has to bring only the lines where the date was the largest one. Example: ID VALOR DATA NOME 1 100 22/05/2...
asked by 22.05.2016 / 19:37
2
answers

When I do the UPDATE it saves in the bank correctly, but when I refresh the page the data comes out of the bank

I'm trying to retrieve data from a table inside an input where the user can be updated and save to the same table through UPDATE. I was able to do the UPDATE, but I edit the data by input and send, it saves in the right bank, but when I refresh...
asked by 02.08.2016 / 17:53