Author Topic: As a manufacturer's home page to add a category to its products Virtemart 2  (Read 450 times)

vladsklyar

  • Beginner
  • *
  • Posts: 23
As a manufacturer's home page to add a category to its products Virtemart 2

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27457
  • Always on vacation
    • Jenkin Hill Internet
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.4.3.10057 on Joomla 3.9.10 PHP 7.0.33
Testing VM 3.5.0.10097 on Joomla 3.9.10

vladsklyar

  • Beginner
  • *
  • Posts: 23
VirtueMart 2.6.12.2
in manufacturer page show category her products

vladsklyar

  • Beginner
  • *
  • Posts: 23
It is for virtuemart 1
Code: [Select]

$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