DaniWeb Forum Index > Web Development > PHP

Adding up numbers in array

Please support our PHP advertiser: 50% Off 6 Months Web Hosting from 1&1. The World's #1 Host!

•

Join Date: Sep 2009

Posts: 9

Reputation: Zack_G is an unknown quantity at this point

Solved Threads: 0

Zack_G

Offline

Newbie Poster

Adding up numbers in array

Sep 11th, 2009

Hi,

I am trying to find the sum of product's weight and can't seam to find anything that can help. I have included my code snippet below.

•

$totalweight = 0;
foreach($_SESSION['ddc']['productsincart'] as $key => $value) {
$sql = "SELECT * FROM ddcart_products WHERE id = '".$key."'";
$result = mysql_query($sql);
$data = mysql_fetch_assoc($result);
//$totalweight = $totalweight+$data['weight'];

echo ' ';
echo $data['name'];
echo ' ';
echo 'Weight: '.$data['weight'];
echo ' ';
echo 'Qty: '.$value;
echo ' ';
$weight = $value * $data['weight'];
echo 'Total Weight: '.$weight;
echo ' ';

}

How can i add up and display the total weight ($weight) for everything listed?

Thank's for your help.
Zack.

•

Join Date: Aug 2007

Posts: 922

Reputation: darkagn has a spectacular aura about

Solved Threads: 130

darkagn

Offline

Posting Shark

Re: Adding up numbers in array

Sep 11th, 2009

You need to iterate through each of the table rows like so:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$sql = "SELECT * FROM ddcart_products";
$result = mysql_query($sql);
$totalweight = 0;
while($data = mysql_fetch_assoc($result))
{
  echo '<br />';
  echo $data['name'];
  echo '<br />';
  echo 'Weight: '.$data['weight'];
  echo '<br />';
  echo 'Qty: '.$value;
  echo '<br />';
  $weight = $value * $data['weight'];
  echo 'Weight: '.$weight;
  echo '<br />';
  $totalweight += $weight;
}
echo "Total Weight = $totalweight<br />";
$sql = "SELECT * FROM ddcart_products";
$result = mysql_query($sql);
$totalweight = 0;
while($data = mysql_fetch_assoc($result))
{
  echo '<br />';
  echo $data['name'];
  echo '<br />';
  echo 'Weight: '.$data['weight'];
  echo '<br />';
  echo 'Qty: '.$value;
  echo '<br />';
  $weight = $value * $data['weight'];
  echo 'Weight: '.$weight;
  echo '<br />';
  $totalweight += $weight;
}
echo "Total Weight = $totalweight<br />";

Last edited by darkagn; Sep 11th, 2009 at 10:50 am.

There are no stupid questions, only those too stupid to ask for help.
echo is a web developer's best friend.

•

Join Date: Sep 2005

Posts: 1,110

Reputation: digital-ether is just really nice

Solved Threads: 68

digital-ether digital-ether is offline

Offline

Veteran Poster

Re: Adding up numbers in array

Sep 11th, 2009

It is probably easier to just use the SUM() function in Mysql:
http://dev.mysql.com/doc/refman/5.0/...functions.html

eg:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
SELECT *, SUM(weight) AS sum_weight FROM ddcart_products...
SELECT *, SUM(weight) AS sum_weight FROM ddcart_products...

www.fijiwebdesign.com - web design and development and fun
Cpanel Email - Let users Register email accounts on your website upon registration
Ajax Chat - Fully browser based chat!