[SOLVED] Array_sum in table column

[pwes24]

Hello everyone. Thank you for being very helpful. I'm creating a shopping cart and I need to add the figures in the 'totals' column.

I know I need to use array_sum but I don't know how to lay down the code. Can someone offer some help?

 

Thank you!

[schilly]

Looks pretty straight forward if you have all your item/qty/price arrays ready: http://ca3.php.net/array_sum

[haku]

You're going to need javascript if you want to show the total real time (while they are entering the numbers)

[pwes24]

How do I write the values of $row['total_price'] as an array so I can apply array_sum?

This is the difficult part

[Barand]

<?php
while ($row = mysql_fetch_assoc($result))
{
     $array[] = $row['total_price'];
}

$total = array_sum ($array);
?>

 

OR

 

<?php
$result = mysql_query ("SELECT SUM(total_price) FROM cart");
$total = mysql_result ($result, 0);
?>

[pwes24]

Thank you sooo much Barand! I got it!