/** * Function to get the name of the vendor the product is associated with * * @param int $product_id * @return string The name of the vendor */ function get_vendorname($product_id) { $db = new ps_DB; $q = "SELECT #__{vm}_vendor.vendor_name FROM #__{vm}_product, #__{vm}_vendor "; $q .= "WHERE #__{vm}_product.product_id='$product_id' "; $q .= "AND #__{vm}_vendor.vendor_id=#__{vm}_product.vendor_id"; $db->query($q); $db->next_record(); if ($db->f("vendor_name")) { return $db->f("vendor_name"); } else { return ""; } }