Math Operations

[alexguz79]

Greetings!!!

 

I know if i want the SUM of al the values in a row i jus do 'SELECT SUM(row) AS row_total FROM table'

 

but how about if i want to substract the values? ex: 2-2-3-1-4

what should i use?

 

thanks

[Mchl]

Add - in front?

[ChemicalBliss]

I think you woudl have to do this in PHP, doubt mysql has that feature - but why would you want to do this?

 

anyway something like this after that query:

$row_total = $row['row_total'];
$inverted = 0 - $row_total;

 

-cb-

[alexguz79]

thanks... i'll try that

[Mchl]

I think you woudl have to do this in PHP, doubt mysql has that feature - but why would you want to do this?

 

anyway something like this after that query:

$row_total = $row['row_total'];
$inverted = 0 - $row_total;

 

 

-cb-

 

How is that different from

SELECT -SUM(row) AS row_total FROM table

or

SELECT SUM(-row) AS row_total FROM table

or even

$inverted = -$row_total;

?