Adding

[me102]

Hello I have a database which is filled with numbers which have + or - in it.

 

 

looks like this,

 

+10.00

-100.00

+45.00

 

Now I have been working with php for a long time and dont have a clue how I would get the total.

[AndyB]

http://www.tizag.com/mysqlTutorial/mysqlsum.php

[me102]

The problem is the numbers have + and - before the numbers will this still work?

[PFMaBiSmAd]

There is one sure way of finding out, try it and see if it works. 

[me102]

There is one sure way of finding out, try it and see if it works. 

 

 

There is another way ::: but ill keep it to myself..... anyways I did try it and didnt work which is why I asked in the first place.

[sasa]

for your data SUM(`field_name`) return -45. is it OK?

[Barand]

it certainly does

 

mysql> select colb from abc;
+------+
| colb |
+------+
| +10  |
| -100 |
| +45  |
+------+
3 rows in set (0.00 sec)

mysql> select SUM(colb) from abc;
+-----------+
| SUM(colb) |
+-----------+
|       -45 |
+-----------+
1 row in set (0.00 sec)

[Clinton]

I've got this below - It was working when I just had one column. But when I added more columns, some had numbers in the signin and some didn't, it stopped working. Any idea?

 

$sumadd = mysql_query("SELECT SUM(signin) FROM `$table` GROUP BY `datecode`") or die(mysql_error());

while($row = mysql_fetch_array($sumadd)){extract($row);
echo "<center>Total Add for $choice = $signin";
echo "<br />";

[Barand]

There is no "signin" column in your result set. Use an alias for the SUM(signin)

 

<?php
$sumadd = mysql_query("SELECT SUM(signin) as signin FROM `$table` GROUP BY `datecode`") or die(mysql_error());

while($row = mysql_fetch_array($sumadd)){extract($row);
echo "<center>Total Add for $choice = $signin";
echo "<br />";

[me102]

Can someone tell me whats wrong with this?

 

 

<?php

$total = mysql_query("SELECT SUM(amount) as amount, FROM `transaction` WHERE `user_id` = '$user_id'") or die(mysql_error());
while($row = mysql_fetch_array($total)){
extract($row);

echo $amount;

}

?>

[corbin]

What datatype is amount?

[me102]

What do you mean?

[corbin]

What datatype is the amount column?  Integer?  varchar?

 

If you don't know how to check, google it.

 

I'm guesing it's some kind of string type since you have a + or -...  (The + probably wouldn't be there if it were a numeric column... unless you're displaying it with modifications.)

 

If it is a string type, MySQL might not add the columns correctly.

[Barand]

Can someone tell me whats wrong with this?

 

 

<?php

$total = mysql_query("SELECT SUM(amount) as amount, FROM `transaction` WHERE `user_id` = '$user_id'") or die(mysql_error());
while($row = mysql_fetch_array($total)){
extract($row);

echo $amount;

}

?>

 

Syntax is wrong. Remove "," from before the "FROM"

[me102]

Can someone tell me whats wrong with this?

 

 

<?php

$total = mysql_query("SELECT SUM(amount) as amount, FROM `transaction` WHERE `user_id` = '$user_id'") or die(mysql_error());
while($row = mysql_fetch_array($total)){
extract($row);

echo $amount;

}

?>

 

Syntax is wrong. Remove "," from before the "FROM"

 

Thank you.

[corbin]

Oh wow....  I'm blind; didn't see that lol.

[Barand]

Oh wow....  I'm blind; ...

 

Agreed

[corbin]

<offtopic (sorry)>

That's hateful.  Nice place to cut it off though.

</offtopic>