Add MySQL Cols

[Nixon]

Hi All,

I have ANOTHER problem. This one is easier to explain though and hopefully easier to solve. I want to minus 3 mysql coloums from each other here is an example:

| ID | Sold | Paid | Extra|
|---------------------------- |
| 1 | 200 | 100 | 50 |
| 2 | 250 | 100 | 50 |

I want to do this equasion:

sold - paid - extra

I want it to apply to all the rows and give me one number. The answer to the table above would be:

200 - 100 - 50 = 50
250 - 100 - 50 = 100

_______Total = 150

I want to access this information through PHP. Could somebody please give me some code to work on?

Thanks. Nixon

[sgoku01]

I think this is what you mean:

$sql = mysql_query("SELECT * FROM database ORDER BY id");

// Set our counter and total price to zero
$counter = 0;
$total_price = 0;

$thing = array();

while ( $r = mysql_fetch_row($sql) )
{
$counter++;
$thing[$counter] = $r['sold'] - $r['paid'] - $r['extra'];
}

for ( $x=1; $x<=$counter; $x++ )
{
$total_price = $total_price + $thing[$x];
}

$thing is an array with the 'minus-prices' and $total_price is the total price 😛

[Nixon]

Hi it just gives me an error that points to the end of the file after the </html>

any ideas?