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)

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More