Welcome Guest, Not a member yet? Register   Sign In
two database insert operations in one function using $this->db->insert()
#1

[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


Messages In This Thread
two database insert operations in one function using $this->db->insert() - by El Forum - 12-17-2009, 07:59 AM



Theme © iAndrew 2016 - Forum software by © MyBB