Questions tagged as 'select'

Tagged questions
0
answers

How do I show options for a select according to the chosen date?

Good evening, I'm developing a lab scheduling site and needed to make a condition in which according to the date the user chooses it will consult in the database all the laboratories that are registered on that date and put in the select only th...
asked by 27.04.2017 / 00:21
0
answers

MySQL - Value limit for mathematical operations

I have a question regarding the following situation: I have two values not stored in a table. Valor 1: 9223372036854775806 (Onde este é o valor máximo de um tipo de dado BIGINT) Valor 2: 99999999999999999999999999999999999999999999999999999...
asked by 19.04.2017 / 21:35
1
answer

Select the values of the "select" through the "GET"

I'm trying and can not do the following: I thought of "automating" the process of reports of the system that I am doing, by registering the PRODUCT, you also register the name of the column id and the name of the product id, as follows: T...
asked by 30.03.2017 / 22:04
1
answer

Concatenate Lines with the same User

I have the following query: SELECT e.id_taxe, u.nm_user, dt_taxe, SUM(e.vl_taxe) as vl_taxe FROM taxe as e INNER JOIN user as u ON u.id_user = e.id_user WHERE id_enterprise = 86 AND (dt_taxe BETWEEN '2017-01-01' AND '2017-03-31') AND lg_can...
asked by 13.03.2017 / 19:11
3
answers

Find information from the bank table with PHP every 10 minutes [closed]

I need to fetch information from a database table every 10 minutes using PHP language. Does anyone have any idea how I can do this?     
asked by 21.03.2015 / 16:56
1
answer

Select in PHP-MySQL with selected

Good evening, I need to populate a select with database information, and when I open the edit page it brings me the option for that user already selected and the other database. if (isset($_GET['id'])) { $valor_selecionado = $row...
asked by 24.02.2017 / 03:07
1
answer

How to optimize a select within an update?

I created a stored-procedure that updates the balances of the Handle table. At first I tried to use From Movimentacao within the update of the move, only that returned error. I fixed this problem by doing FROM (SELECT * FROM M...
asked by 31.01.2017 / 21:54
1
answer

PHP | MYSQL Error: Operand should contain 10 column (s) [closed]

I'm trying to develop a Query where, it needs to be queried in 6 equal tables if there is any specific value. Here's my Query: SELECT ( CASE WHEN (SELECT * FROM sala1 WHERE aluno = '$AlunoInformado') = 1 THEN END ELSE CASE...
asked by 10.01.2017 / 02:43
0
answers

SQL query for ASP.NET page with C #

On my client's site, I have a SQL query that brings the readiness result of multiple collaborators. However, for the moment I can only translate the result of the query into a GridView: SQL CONSULTATION SELECT codigoAvaliacao, codigoColab...
asked by 18.01.2017 / 18:08
1
answer

SQL - Select with possible concatenation

I created a query that concatenates my results. It is a table with names and which range (square) they are sorted. The table is named prompt_name and the fields are name and square : Select Main.Quadrado, Left(Main.Nome,Len(Main.Nome)-...
asked by 23.01.2017 / 18:12