News:

Looking for documentation? Take a look on our wiki

Main Menu

Add to cart products derived

Started by tazcabe, October 12, 2014, 09:47:00 AM

Previous topic - Next topic

tazcabe

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]