I have the following sentence that helps me to update the fields of a detail_dulce table that collects only numerical values
update producto
inner join detalle_dulce on detalle_dulce.idp = producto.idp
inner join existencia on producto.idp = e...
I have a problem in this query, it consists of 3 sheets, one where I enter an email from a table to find a specific student, another where I change the course and another that modifies the course of the student table.
The problem is that I ha...
Use CodeIgniter and PHP. When doing an Update, no message is displayed and the update is not done.
client_search (controller):
public function mod(){
$mod=$this->main_model->mod(
$this->input->post("DocIdent"...
You have a table with column salary , and column bonus .
The salary column has numeric data, the bonus column is a numeric type but it is empty.
It is possible to create a stored procedure through which you can insert data to the whole b...
Use Codeigniter with php, in a tutorial a crud is done, I already had the insert and I tried to adapt the code to make an update, but the code of the tutorial calls the model mod twice, and in one it happens only 1 argument. I think that's why i...
I use Codeigniter and php, I try to make an update, I do the initial selection well, then I go to a form that receives the data that will be modified, but I have problems sending the data to the controller.
modify_view
<!DOCTYPE HTML>...
I have been trying to use a trigger to update a record after I entered it, the problem is that the following code does not work for me:
CREATE TRIGGER 'test_trigger' AFTER INSERT ON 'chat_test_trigger'
FOR EACH ROW UPDATE chat_test_trigger SE...
I try to do an "edit" clients, but it does not work at all.
Is it possible that it is because the form , I get it by PHP in a query?
I will explain my code:
First of all:
The form , comes from a query, by clicking...
Can an UPDATE be made to two tables at the same time? I'm doing this but obviously it does not work:
<?php
$id = $_POST['eIdp'];
$producto = $_POST['eidPr'];
$factura = $_POST['eNumero'];
$eFecha = $_POST['eFecha'];
$eVencimiento = $_P...
Thanks in advance for your answers.
I have a php system in which several users work at the same time.
It happens that a work order is loaded labor and spare parts. Different users can edit the same order. The problem is that when a user edits...