Feature problem

[Rod]

Hi teams, thanks for your hard working. Now I have a question,and do not know how to solve this.Can you please help me.

For example,I creat following features:
SST-->value is 345---first creat
BBS-->value is 453---second creat
TTK-->value is 456---third creat
AAC-->value is 543--fourth creat

When I update,they will show as following:
TTK: 456
SST:345
BBS:453
AAC:543

But I like it to array who creat first and who show first. as
SST: 345:
BBS:453
TTK:456
AAC:543

I am not English,hope you can understand what I say :-(

[soju]

Hi

You can reorder features table on you mysql server :
ALTER TABLE `ps_feature` ORDER BY `id_feature`
ALTER TABLE `ps_feature_product` ORDER BY `id_feature`

Or modify function getFrontFeaturesStatic in classes/product.php

[Rod]

Hi thanks,i modify the function as following,but it do not work

static public function getFrontFeaturesStatic($id_lang, $id_product)
{
return Db::getInstance()->ExecuteS('
SELECT name, value, pf.id_feature
FROM '._DB_PREFIX_.'feature_product pf
LEFT JOIN '._DB_PREFIX_.'feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = '.intval($id_lang).')
LEFT JOIN '._DB_PREFIX_.'feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = '.intval($id_lang).')
WHERE pf.id_product = '.intval($id_product).');
}

to following:

static public function getFrontFeaturesStatic($id_lang, $id_product)
{
return Db::getInstance()->ExecuteS('
SELECT name, value, pf.id_feature
FROM '._DB_PREFIX_.'feature_product pf
LEFT JOIN '._DB_PREFIX_.'feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = '.intval($id_lang).')
LEFT JOIN '._DB_PREFIX_.'feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = '.intval($id_lang).')
WHERE pf.id_product = '.intval($id_product).' ORDER BY pf.id_feature');
}

[soju]

It should work.
Check ps_feature/ps_feature_lang tables to see if features are in the right order (sst, bbs, ttk, aac).