/** * Function to get the manufacturer id the product $product_id is assigned to * @author soeren * @param int $product_id * @return int The manufacturer id */ function get_manufacturer_id($product_id) { $db = new ps_DB; $q = "SELECT manufacturer_id FROM #__{vm}_product_mf_xref "; $q .= "WHERE product_id='$product_id' "; $db->query($q); $db->next_record(); if ($db->f("manufacturer_id")) { return $db->f("manufacturer_id"); } else { return false; } }