Display Product Attribute in Frontend

[AarthyV]

Hi,

I want to retrieve the value of product_attribute from virtuemart_order_items table and want to display in the same order as shown in checkout page.

I am using customer text input plugin in Vm2 for each product so that the user can type their comment for that product.

For example,
Comment: good
Saved in the database as {"134":{"textinput":{"comment":"good"}}

So how to retrieve "good" from the database.

Using:
Joomla 2.5
Virtuemart 2.0


Thanks in advance
AarthyV

[jenkinhill]

http://forum.virtuemart.net/index.php?topic=79799.0

[GJC Web Design]

you don't say what column this is saved to  - but you access that in your template as any other node
It is in json format so you need to   php  json_decode($your_var) which will give you an object

also the example you give is syntax incorrect - missing a closing brace

{"134":{"textinput":{"comment":"good"}}}