Mysql insert not working properly

[eluser]vitoco[/eluser]
So you need to convert two arrays with ids into one with this format :

Code:

$data = array(
  array(
    'product_column' => $product2,
    'cat_id_column'  => $cat_id2
  ),
  array(
    'product_column' => $product,
    'cat_id_column'  => $cat_id
  ),
  array(
    'product_column' => $product3,
    'cat_id_column'  => $cat_id3
  )
);

I think this may help ( only if the indexes are coincident between the two arrays )

Code:

$data = array();

foreach( $product as $index => $value )
{
    $data[] = array(
        'prduct_id'    => $value ,
        'category_id'  => $cat_id[ $index ]
    );
}

$this->db->insert_batch('table_name', $data);

Slds