[eluser]core-coder[/eluser]
Hi all
How can I perform two insert operations to two tables in a function ?
I tried following code
Code:
$this->subproduct = $name;
$this->status = 1;
$this->db->insert('subproduct', $this);
$insert_id = $this->db->insert_id();
$this->subp_id = 2;
$this->prd_id = $insert_id;
$this->db->insert('product_subproduct', $this);
I am getting following error
Quote:A Database Error Occurred
Error Number: 1054
Unknown column 'subproduct' in 'field list'
INSERT INTO `product_subproduct` (`subproduct`, `status`, `subp_id`, `prd_id`) VALUES ('xxx', 1, 2, 19)
How can I reset values in $this after first insertion ?
Thanks