As a manufacturer's home page to add a category to its products Virtemart 2

[vladsklyar]

As a manufacturer's home page to add a category to its products Virtemart 2

[jenkinhill]

What is the question?   http://forum.virtuemart.net/index.php?topic=104795.0

[vladsklyar]

VirtueMart 2.6.12.2
in manufacturer page show category her products

[vladsklyar]

It is for virtuemart 1

Code Select Expand



$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