Jump to content

How get 'product_name' with Attribute Value, but without Attribute Group?


Recommended Posts


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:


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?

Edited by JirkaDeLucina (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...