Posts by Diogo Carvalho • 49 points
9 posts
-
2
votes1
answer255
viewsQ: How to make a weekly mysql query
Good morning everyone! I would like a Help!!! I am in doubt of how to make a weekly mysql query, starting on Monday and ending on Sunday, and the data will be inserted every day, and from the data…
-
0
votes3
answers105
viewsQ: Error in Mysql query
Hello! this doubt arose in mysql query; because the status is coming different from the table? follow my consultation: SELECT DISTINCT max(idEmbreagem) as idEmbreagem, b.prefixo as idVeiculo,…
-
0
votes1
answer222
viewsQ: ERROR Parse error: syntax error, Unexpected '<'
this error appears in my code: Parse error: syntax error, Unexpected '<' in /home/Storage/3/da/ca/public_html/Viewrevisao.php on line 110 What would be the solution in this case <?php…
-
0
votes2
answers1371
viewsA: How to avoid duplication of record in a table in mysql
I ended up making some changes and it worked. thanks for the LIGHT that Voce gave me.... $query = "SELECT * FROM veiculos WHERE placa = '" . $_POST['placa'] . "'"; $resulta = mysqli_query($conn,…
-
1
votes2
answers1371
viewsQ: How to avoid duplication of record in a table in mysql
How do I not let repeat the plate in the register? <?php $placa = $_POST['placa']; $cidade = $_POST['cidade']; $estado = $_POST['estado']; $query = "INSERT INTO veiculos (placa, cidade, estado)…
-
1
votes1
answer56
viewsQ: Update record in table using Selected in MYSQL
I’ve got this problem I can’t seem to solve. I have the following tables in the database: And in the form he pulls the correct data, but now that I will update for example only the plate and do not…
-
0
votes1
answer292
viewsQ: How to sum a database record plus input with Jquery
Hello how do I make this sum with Jquery: have this table vehicles in the database with the review column of 500 in the form when I choose the prefix MT-02 I want it to sum the input of the exchange…
-
0
votes1
answer221
viewsQ: How to Subtract MYSQL
How to do the correct subtraction of these two columns in the SQL script? SELECT DISTINCT b.prefixo as idVeiculo, max(datatroca) as datatroca, max(kmtroca) as kmtroca, max(horimetroca) as…
-
0
votes1
answer70
viewsQ: How do I subtract and display the result in the MYSQL query
I have 3 tables Vehicles idVeiculo | Placa | Prefixo oleomotor idMotor | idVeiculo | datatroca | kmtroca | horimetroca | proximatroca |idMecanico I already have this query below that shows the…