PHP and MYSQL Help

[stesouthby]

Hi I have a transaction database where when you up date the traction of a product it is place on the that as like 200 or -50 and it carrys on like this in a list I was wondering what code would i need to do to add all the mysql tranactions up to get a total and place it on in a products table or displays it on the home page any help would be greatful i know i will need to do a mysql query to get all the ones i need i just don't know where to go from there

 

[misson]

What?

 

[stesouthby]

ok right if you have a list of numbers in a mysql database is the away to add and subtract them all to get a total for example if it would be listed as ethier 20 or -20 is there away to do that?

 

[misson]

SQL has aggregate functions that operate on grouped columns, returning a single value for the group. In this case, SUM should do what you want.

SELECT SUM(delta) FROM transactions GROUP BY product;

If you need something more specific, you'll need to include a minimal test case, which (for this question) would be a table schema (definition) and test data. For example,

CREATE TABLE transactions (
    id INT PRIMARY KEY AUTO_INCREMENT,
    delta INT,
    product INT /* REFERENCES products (id) ON DELETE CASCADE ON UPDATE CASCADE */,
) Engine=InnoDB;

INSERT INTO transactions (delta, product)
  VALUES
    (20, 0),
    ...
  ;

Also, this.