$query = $db->query("SELECT * FROM orders");
while ($row = mysql_fetch_array($query)) {
$cost= array_sum($row['cost']);
}
This is not working, I want to to calculate the sum of all elements but I get this error:
Warning: array_sum() expects parameter 1 to be array, string given in C:\xampp\htdocs\falco\classes\controller.php on line 303
Any idea how to calculate all the elements coming from mysql?
Thank you for your time and help.
Why not let MYSQL handle it?
$query = $db->query("SELECT orders.*,SUM(cost) as sum_cost FROM orders");
If its just a sum you want you can let the database do it for you:
Select sum(cost) from orders
Try this:
$query = $db->query("SELECT * FROM orders");
$cost = 0;
while ($row = mysql_fetch_array($query)) {
$cost += $row['cost'];
}
Or from mysql:
$query = $db->query("SELECT sum(`cost`) as `cost` FROM orders");
while ($row = mysql_fetch_array($query)) {
$cost = $row['cost'];
}
this should work:
$query = $db->query("SELECT * FROM orders");
$cost = 0;
while ($row = mysql_fetch_array($query)) {
$cost += $row['cost'];
}
or even better
$query = $db->query("SELECT SUM(cost) FROM orders");
list($cost) = mysql_fetch_row($query);
Really, it sounds like you just want the sum.
'SELECT SUM(cost) as sum_cost FROM ORDERS'
cost. The answers provided below are reasonable options, especially theselect sum(cost) from foo...mysql statement