VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: vladsklyar on October 16, 2016, 11:50:07 AM

Title: As a manufacturer's home page to add a category to its products Virtemart 2
Post by: vladsklyar on October 16, 2016, 11:50:07 AM
As a manufacturer's home page to add a category to its products Virtemart 2
(http://i.piccy.info/i9/1e9ecf2752be2d120b510912c0ab74ec/1476611340/26315/1080163/Bezymiannyi_3__500.jpg) (http://piccy.info/view3/10401083/bb30ab9cd1568539764f04116fa4a437/)(http://i.piccy.info/a3/2016-10-16-09-49/i9-10401083/500x301-r/i.gif) (http://i.piccy.info/a3c/2016-10-16-09-49/i9-10401083/500x301-r)
Title: Re: As a manufacturer's home page to add a category to its products Virtemart 2
Post by: jenkinhill on October 16, 2016, 12:53:36 PM
What is the question?   http://forum.virtuemart.net/index.php?topic=104795.0
Title: Re: As a manufacturer's home page to add a category to its products Virtemart 2
Post by: vladsklyar on October 16, 2016, 12:58:24 PM
VirtueMart 2.6.12.2
in manufacturer page show category her products
Title: Re: As a manufacturer's home page to add a category to its products Virtemart 2
Post by: vladsklyar on October 16, 2016, 13:06:52 PM
It is for virtuemart 1


$q = "SELECT c.category_id, c.category_name FROM #__{vm}_category c, #__{vm}_product_category_xref cx, #__{vm}_product_mf_xref mx

WHERE c.category_id=cx.category_id AND cx.product_id=mx.product_id AND mx.manufacturer_id=$manufacturer_id";

$db->query($q);

$cat="";

and how to make to virtuemart 2