/** * Function to create a db object holding the data of all child items of * product $product_id * * @param int $product_id * @return ps_DB object that holds all items of product $product_id */ function items_sql($product_id) { $db = new ps_DB; if( !empty($product_id) ) { $q = "SELECT * FROM #__{vm}_product "; $q .= "WHERE product_parent_id=".(int)$product_id.' '; $q .= "ORDER BY product_name"; $db->setQuery($q); $db->query(); } return $db; }