Hi good morning
I hope you can support me with the problem that I have, I put my versions of Joomla and Virtuemart:
Joomla! 2.5.22
VirtueMart 2.6.8
I am modifying a view of my products, in which I want agrear a listing of all products derived from this product.
I put down the image of hope as it is my final view.
However I am having trouble to create a button add to cart for each of the products.
To have the list of these products generate a query which I share:
$db = &JFactory::getDBO();
$q = 'SELECT *
FROM `#__virtuemart_products`as p, `#__virtuemart_products_es_es` as d, `#__virtuemart_product_prices` as r
WHERE `p`.`virtuemart_product_id` = `d`.`virtuemart_product_id`
and `p`.`virtuemart_product_id` = `r`.`virtuemart_product_id`
and `p`.`product_parent_id`= "'.$this->product->virtuemart_product_id.'" ';
$db->setQuery($q);
$result = $db->loadObjectList();
and I want to do is generate a botton to add to cart with the id of these products, which I have on the subject:
$ result-> virtuemart_product_id
Can you help me please
acutal view
[attachment cleanup by admin]