Jump to content

Edit History

ps8modules

ps8modules

If there is only one value, it's simple.

$idlang = 1;
$idFeature = 14;
$idProduct = 222;

$getFeatureValue = Db::getInstance()->getValue('
	SELECT a.value FROM '._DB_PREFIX_.'feature_value_lang a 
	LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value)
    WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang);

Result one value:

obrazek.png.3586de99326ea52c54dd2a274e3ea47a.png

ps8modules

ps8modules

If there is only one value, it's simple.

$idlang = 1;
$idFeature = 14;
$idProduct = 222;

$getFeatureValue = Db::getInstance()->getValue('
	SELECT a.value FROM '._DB_PREFIX_.'feature_value_lang a 
	LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value)
    WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang);

 

×
×
  • Create New...