[eluser]zyklon[/eluser]
Yes i know this but i don't know how to compose the array in this case.Because for example i have
$data["specification_category_name"] = $specification_category_name;
In 2 foreach.They execute both.Basically i have in 2nd foreach,the both arrays,
Code:
$data["specification_category_name"] = $specification_category_name;
and
Code:
$data[subspecifications] => array(
array(’subspecification_name’ => $subspecification_name),
array(’subspecification_value’ => $product_specification_value
);
They are both in the 2nd foreach as i said.
Or look at this another try below.Shouldn't work?
Code:
$data["specification_categories"] = array();
foreach($result as $key => $value)
{
$product_specification_value = $value["product_specification_value"];
$result_category_spec = $this->lugnuts->get_products_category_specification_id($tableName,$id_product);
foreach($result_category_spec as $key_2 => $value_2)
{
$product_specification_category_id = $value_2["product_specification_category_id"];
$result_spec_id = $this->lugnuts->get_products_specification_id($tableName,$id_product,$product_specification_category_id);
foreach($result_spec_id as $key_4 => $value_4)
{
$result_spec_id_value = $value_4["product_specification_id"];
$specification_category_name_res = $this->lugnuts->get_category_specification_name($tableNameproducts_specifications_categories,$product_specification_category_id);
$specification_category_name = $specification_category_name_res->product_specification_category_name;
$data["specification_category_name"] = $specification_category_name;
$subspecification_name_result = $this->lugnuts->get_category_subspecification_name($tableNameproducts_specifications_subspecifications,$result_spec_id_value);
$subspecification_name = $subspecification_name_result->product_specification;
$data["subspecifications"] = array(
'subspecification_name' => $subspecification_name,
'subspecification_value' => $product_specification_value
);
$data["specification_categories"][] = array_merge((array)$data["specification_category_name"],$data["subspecifications"]);
}
}
or another try below:
Code:
foreach($result as $key => $value)
{
$tmp = array();
$product_specification_value = $value["product_specification_value"];
$tmp['subspecifications'] = array();
$result_category_spec = $this->lugnuts->get_products_category_specification_id($tableName,$id_product);
foreach($result_category_spec as $key_2 => $value_2)
{
$product_specification_category_id = $value_2["product_specification_category_id"];
$result_spec_id = $this->lugnuts->get_products_specification_id($tableName,$id_product,$product_specification_category_id);
foreach($result_spec_id as $key_4 => $value_4)
{
$result_spec_id_value = $value_4["product_specification_id"];
$specification_category_name_res = $this->lugnuts->get_category_specification_name($tableNameproducts_specifications_categories,$product_specification_category_id);
$specification_category_name = $specification_category_name_res->product_specification_category_name;
$tmp['specification_category_name'] = $specification_category_name;
$subspecification_name_result = $this->lugnuts->get_category_subspecification_name($tableNameproducts_specifications_subspecifications,$result_spec_id_value);
$subspecification_name = $subspecification_name_result->product_specification;
$tmp["subspecifications"][] = array(
'subspecification_name' => $subspecification_name,
'subspecification_value' => $product_specification_value
);
}
}
$data["specification_categories"] = $tmp;
}