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

Started by vladsklyar, October 16, 2016, 11:50:07 AM

Previous topic - Next topic

vladsklyar

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

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

vladsklyar

VirtueMart 2.6.12.2
in manufacturer page show category her products

vladsklyar

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