sosidge Posted February 2, 2005 Share Posted February 2, 2005 Hi there, I'm trying to quickly find out the total value of stock of hold at present. I imagine there is an easy way to do this with an operation on the MySQL database - but I don't know where to start. Basically, in the products table, I need products_quantity to be multiplied by products_price for each products_id, and for the whole lot to be summed. Any help much appreciated. - osCommerce is fun! - Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.