Hi,
i have to make a query with gives me this structure.
P=Array (
[0] => Array (
[id__dic] => 79
[id__shop] => 1
[id__lang] => 2
[symbol] => uoi
[parent_symbol] => Mich
[root_symbol] => 0
[folder] => 1
[oorder] => 2
[active] => 1
[prefix] => dfield
[name] => array(
[1] => arrw
[2] => arw
)
[description] => array(
[1] => arrw
[2] => arw
)
)
)
I created two queries like in bottom code, but i thing there is a better solution. Could you help me and give some suggestion?
.....
$sql = "
SELECT dic.*, ldic.*
FROM "._DB_PREFIX_."dp__shop dic
LEFT JOIN "._DB_PREFIX_."dp__lang ldic
ON (dic.id_dp = ldic.id_dp
AND dic.id__shop = ldic.id__shop)
WHERE dic.id_dp__shop = '".$id_shop."'
AND dic.symbol = '".$parent_s."'
AND ldic.id_dp__lang = '".$id_lang."'
ORDER BY dic.oorder ASC, dic.id_dp ASC
";
$dic_BySymbol = Db::getInstance()->executeS($sql);
$sqls = "SELECT name, description";
$sqls .= "FROM "._DB_PREFIX_."dp__lang";
$sqls .= "WHERE id_dp__shop = '".$id_shop."'";
$sqls .= "AND id_dp = '".$dic_BySymbol['0']['id__dic']."'";
$dic_BySymbolSubqueryLang = Db::getInstance()->executeS($sqls);
$dic_BySymbol['name'] = array();
$dic_BySymbol['description'] = array();
foreach ($languages as $language)
{
$dic_BySymbol['name'][$language['id_lang']] = $dic_BySymbolSubqueryLang->name[$language['id_lang']];
$dic_BySymbol['description'][$language['id_lang']] = $dic_BySymbolSubqueryLang->description[$language['id_lang']];
}
return $dic_BySymbol;
}