Good evening,
I have the following select that is to search for users according to their category:
$consulta = "SELECT * FROM app_usuarios WHERE cat = '$categ'
$ categ is the variable that I get dynamically according to the user's choic...
I need to access a database where I put the data myself, the insert part is working, but now I need to "get" the data again when I click the button, so it does not matter what way I do it you always get this error message:
System.InvalidOp...
I'm having a problem performing a query .
The original table calls tbl_operacao , and contains the fields:
id , tipo_operacao , idimovel , idproprietario , idlocatario , idseguro , idvalores ....
I am creating a mysql table where it contains the date of an event. The question is as follows: if in the current day there is an event it is highlighted otherwise the next day. would you have any idea how to do it?
The query for the current day...
I have the following problem, I have two stocks in my company, so I have two values for the stock, and the stock record looks something like this:
Astheimageshows,eachproducthastworecords,eachreportingthequantityofeachstock.Icannotchangethew...
Good morning, how do I make my clause affect only one (1) field in my search? For example:
$query = DB::table('proventosdesc as proven')
->join('calculo_rh as calc', 'proven.pessoaId', '=', 'calc.pessoaId')
->join...
I have a page where I will have to make several queries to the bank. At present, they are a total of three tables. They are: cadastro , publicacoes and estilo . Currently I do this:
SELECT nome, sobrenome, usuario, email FRO...
I have a query in MySQL that, in the command line and in MySQL Workbench, is bringing the correct values, but when executed in PHP, the GROUP BY function is grouping more than it should!
Here is the query:
SELECT
DATE_FORMAT(ctg.d...
I'm trying to display a list of subscriptions for a particular user. The getuser() method captures the id of the session user and displays the list of entries created by it.
However, I'm trying to display these records on screen, while...
I made a select using metadata, but the result of my selection brought me something like a 'Cross Join'. Even using GROUP BY and DISTINCT returns with the duplicate values. I would like a help for the values to return correctly ... follows the s...