/** * Function to get the vendor_id of a product * @author pablo * @param int $product_id * @return int The vendor id */ function get_vendor_id($product_id) { $db = new ps_DB; if( empty( $_SESSION['product_sess'][$product_id]['vendor_id'] )) { $q = "SELECT vendor_id FROM #__{vm}_product "; $q .= "WHERE product_id='$product_id' "; $db->query($q); $db->next_record(); if ($db->f("vendor_id")) { $_SESSION['product_sess'][$product_id]['vendor_id'] = $db->f("vendor_id"); } else { $_SESSION['product_sess'][$product_id]['vendor_id'] = ""; } } return $_SESSION['product_sess'][$product_id]['vendor_id']; }