I published a question yesterday, but another very similar problem arose, I already verified the connection to my database (it is correct), I already did "SELECT" of all my table and answered correctly, and update records and if you update them...
I want to make people with the reader role, only see the contents of their rows, but the administrator sees everything, I'm using this code but I do not understand why it does not work. I do not see where the error is here in the logic, because...
Good to have if I can explain everything; I have two tables in the BD:
productos
+----+----------+--------+
| id | producto | estado |
+----+----------+--------+
| | | |
| | | |
+----+----------+...
I explain: It turns out that I have a procedure that establishes two integer parameters, which are then arranged to store each the result of a single value that comes from different columns one for each, the select that I have is some...
I have 2 tables one with the general data of Routes and another of Inscriptions of each partner, I want to update the table Routes with the sum of two fields of the table of Registrations and I get the error:
# 1241 - Operand should contai...
Good afternoon. I do not know why this query is not done in PHP and Mysql
This is the code of the form to send the content:
<?php
session_start();
if(!isset($_SESSION['usuario']))
{
header('Location:auth');
exit();
}
include 'conexion.ph...
I have the following code that generates a table in php, returning the data saved in a database in mysql
require("conexion.php");
$consulta = mysqli_query($conexion, "SELECT * FROM clientes");
if (!$consulta) {
die("Fallo al realizar la...
I have a loop that runs through an array that comes from a multiple select and stores the results in mysql.
The fact is that there is the option that this select does not exist, so the loop does not make sense. I have tried to enter a conditi...
I am trying to make a query in MySQL, I have a table that contains the following:
table: id, ano, m1, m2, m3, m4, m5, m6, m7
data: 10, 2016, I, P, L, I, L, P, I
That is, what I want to achieve is...