Hi,
I call in PS 1.7.4:
...
SELECT psod.*, msod.*, pl.`name` as `product_name`, pl.`description`, pl.`link_rewrite` FROM `' . _DB_PREFIX_ . 'order_detail` as psod
and if I want to write it on page, I use:
{$product_detail['product_name']}
There is problem, I get only short product name, without Attribute value (eg.: Mobile phone). If I delete pl.`name` as `product_name` I get long product name with Attribute Group and Attribute Value (eg.: Mobile Phone - Type : for older).
But my goal is get: Product name - Attribute Value (eg.: Mobile Phone - for older)
(without Attribute Group).
What should I change?