I need to query in a table called controls:
I have the column CH which is the hourly load in minutes and I have the column SETOR which are the sectors that participated in some training.
I need to make an appointment wh...
Good afternoon
I was trying to adapt a code I already had here to be able to by a watermark on a photo. But there's plenty of time I do not deal with html or php. So could you guys give me this help to fix the problem of selecting the correct...
My code returns the database query, but lists only the last item entered, and lists it infinitely. I wonder where I'm going wrong.
<?php
//Início da listagem
$servidor = 'localhost';
$usuario = 'root';
$senha = '';
$banco = 'portfolio';...
I'm trying to get all the option's of a select that I have, but I've already used everything that is jQuery code, but they do not. I am making a filter where the person will select a city and after selecting jQuery makes a reques...
Good afternoon!
I have a task to perform a select, but the parameters are passed as variables and I need to treat the input of one of these variables with the following logic: if & CT is not null, then I add in the condition of select the...
In a given select I can reference two tables by foreign keys.
Ex: IdA / IdB
IdA = IdB
Table A has a column named C
Table B has three columns called D, E, F
Both tables have similar contents for returns in SELECT
Ex:
Select ... fr...
I have a select that displays the names, date and values paid by clients.
I have to display a list without repeating the names.
SELECT
c.name,
p.created_at,
p.amount_paid
FROM
payments as p,
clients as c
WHERE
p.crea...
I'm trying to use this code below, but oracle returns me the following error:
ORA-00907: right parenthesis not found
00907. 00000 - "missing right parenthesis"
* Cause:
* Action:
Error on line: 30 Column: 10
I can not identify...
How do I make a select that assigns the value "10" in all of the games column?
NOTE: Do not give update in the table.
/*minha_tabela*/
codigo jogos
---------------------
1 10
2 10
3 10...