[pmalerba]

I can't understand how the multilanguage works

I tried this query :

$manufacturer_data = func_query_first("SELECT $sql_tbl[manufacturers].*, IF($sql_tbl[images_M].id IS NULL, '', 'Y') as is_image, IFNULL($sql_tbl[manufacturers_lng].manufacturer, $sql_tbl[manufacturers].manufacturer) as manufacturer, IFNULL($sql_tbl[manufacturers_lng].descr, $sql_tbl[manufacturers].descr) as descr FROM $sql_tbl[manufacturers] LEFT JOIN $sql_tbl[manufacturers_lng] ON $sql_tbl[manufacturers_lng].manufacturerid = $sql_tbl[manufacturers].manufacturerid AND $sql_tbl[manufacturers_lng].code = '$shop_language' LEFT JOIN $sql_tbl[images_M] ON $sql_tbl[images_M].id = $sql_tbl[manufacturers].manufacturerid WHERE $sql_tbl[manufacturers].manufacturerid = '$manufacturerid'");

and

$query_data = array(
"url" => $url,
"descr" => $descr
);
$query_data_lng = array(
"manufacturerid" => $manufacturerid,
"code" => $shop_language,
"descr" => $descr
);

But using {$query_data_lng|@debug_print_var} or {$manufacturer.descr|@debug_print_var}
I get NULL

I'm sorry but I'm newbe with php

Any help?

Thanks for support.