Questions tagged as 'mysql'

1
answer

SELECT Mysql with wrong result

Let's take the table below as an example: id empresa forneedor 1 10 105 2 10 102 3 10 105 4 10 112 5 10 105 Using business and vendor as indexes. Making SELECT * FROM table...
asked by 14.10.2015 / 22:27
0
answers

Jasper Data Filter: Between two dates

I'm having a hard time generating a report in Jasper through java. In Jasper my query all correct, most when I perform through the java presents error. Report query code: select fornecedores.matricula_em, fornecedores.nome_em,fornecedores.e...
asked by 05.01.2019 / 01:01
1
answer

You can not specify target table 'person' for update in FROM clause

I'm testing the operation of a subquery (subquery) and running the command below: DELETE FROM pessoa WHERE id IN(SELECT id FROM pessoa WHERE id=2 ); The following error occurs:    You can not specify target tab...
asked by 24.08.2018 / 16:04
2
answers

MySql Conversion To PDO

@$sql_usuario = "SELECT * FROM usuario "; @$qry_usuario = @mysql_query($sql_usuario ); @$linha_usuario = mysql_fetch_array($qry_usuario ); Array ([0] => 6 [u_id] => 6 [1] => 54354554 [u_cod] => 54354554 [2] => 54354554 [u_cod] => 54354554)...
asked by 29.11.2018 / 15:34
1
answer

Take data from a page and move to the database

I want to make sweepstakes via WhatsApp. To participate, the person would send a message with the name to the number that I will announce and it will receive the confirmation response and the token number. I wanted the bot to take the phone n...
asked by 09.11.2018 / 15:45
1
answer

How to read items from one array inside another?

This is my multidimensional array: <?php $beneficiarios = array ( array( "codigo_membro" =>$cod, "nome" => $_POST['nome1'], "n_identificacao" => $_POST['n_i...
asked by 19.10.2018 / 15:09
1
answer

How to update the name of an image in the bank?

This script is to enter the name of the image in the bank, it is working normally INSERIR.PHP if ($_POST){ $imagem = $_FILES['img_post']; $nomeImg = $imagem['name']; $tmpImg = $imagem['tmp_name']; $formatoBase = explode...
asked by 17.10.2018 / 13:42
3
answers

Category Sum and SubCategory with PHP and MYSQL

I have already broken my mind and am lost in how to find the solution to my problem, I am developing a financial report that has categories and subcategory (7 levels) Below the structure of part of my table and how is some data: Thereportwor...
asked by 22.10.2018 / 21:45
1
answer

Column id with primary key and auto increment is returning null MYSQL PHP

Good night guys, this is the following, I have an application that was working until these days, today when I was adding a post in the database, my id_post that is Primary Key and Auto_increment is not being added, it returns the error that it m...
asked by 14.09.2018 / 00:39
1
answer

List MySQL data with PHP and Bootstrap

Hello, I'm having difficulty listing values from a table, I think it's a syntax error, because neither the html data appears, it follows the code: $query = sprintf("SELECT * FROM entrega_cliente"); // executa a query...
asked by 29.09.2018 / 13:52