/** * Functon to get the name of the manufacturer this product is assigned to * * @param int $product_id * @return string the manufacturer name */ function get_mf_name($product_id) { $db = new ps_DB; $q = "SELECT mf_name,#__{vm}_manufacturer.manufacturer_id FROM #__{vm}_product_mf_xref,#__{vm}_manufacturer "; $q .= "WHERE product_id='$product_id' "; $q .= "AND #__{vm}_manufacturer.manufacturer_id=#__{vm}_product_mf_xref.manufacturer_id"; $db->query($q); $db->next_record(); if ($db->f("mf_name")) { return $db->f("mf_name"); } else { return ""; } }