Hi Daniel,

could you describe for me what kind of parameters these are? Some sort of custom parameters in VM? And what version of  Joomla and VM?

Thanks,
Stephen

Hi,

it took me a while to get these versions of Joomla and VM installed for testing, but I got there :-)

I then had to look in the database table "jos_vm_product_type_parameter" to see what ID number the parameter is stored as. e.g.

product_type_id: 4
parameter_name: size

So in my test case, the id number is 4. Now I have to use this to construct another table name, "jos_vm_product_type_4" using the id number 4 at the end.

Now that I have this table name I can query this table to see what the parameter value is for a particular product. To get the product ID number I can use JomGenius, when I am on a VM product page.

e.g.

$vm = JomGenius("virtuemart");
if ($vm->check("pagetype = shop.product_details")) {
  $prod_id = $vm->info("product_id");
  $query = "select size ".
     "from jos_vm_product_type_4 where product_id = " . (int)$prod_id;
  $sql->setQuery($query);
  $result = $sql->loadResult();
  if ($result == "large") return XXX:
  if ($result == "medium") return YYY:
  if ($result == "small") return YYY:
  // replace XXX, YYY, ZZZ with the module ids of the modules to use
  // for the relevant sizes.
}

Now I can see from your original forum post that your situation is more complex, with more parameters etc. Can you give a few real examples of these values and I should be able to suggest modifications to my code above that are more suited to your situation.

Best regards,
Stephen

So... all solved now?

Great, thanks for letting us know. All the best for you site.

Stephen