/** * Function to create a ps_DB object holding the data of product $d['product_id'] * from the table #__{vm}_product * * @param int $product_id * @return ps_DB DB object holding all data for product $product_id */ function sql($product_id) { $db = new ps_DB; if( !empty( $product_id )) { $q = 'SELECT * FROM #__{vm}_product WHERE product_id=' . (int)$product_id; $db->setQuery($q); $db->query(); } return $db; }