Another Array Question

GundamSV7

Hi there,

I was wondering how I could add together all the values of an array returned by a form. My form basically is like a shopping cart, consisting of a lot of checkboxs and I simply want to add the values of all the checkboxes together. For example:

$d1 = mysql_query("SELECT * FROM db WHERE 1");
while($d2 = mysql_Fetch_array($d2)) {
<input type=checkbox name=cb[] value=$data[db1num]>
}

That gets all the values from my database and I want to just add together the price field. I've already searched these forums and haven't really found a working solution to this, any help would be much appreciated.

Thanks

drew010

[man]array_sum[/man] will do it.

GundamSV7

so, would it be something like this?

$a = array($cb);
echo "sum(a) = " . array_sum($a) . "\n";

drew010

ill guess that the form is going to be posted, so it'd be like this

$num = array_sum($_POST['cb']);

GundamSV7

sorry, I forgot to mention this sooner, the cb array is just a bunch of database ID numbers. I need to query to db to get the actual prices. Such as:

 foreach ($cb as $value) { 
      $query = "SELECT * from db WHERE dbnum = '$value'"; 
      $result = mysql_query($query); 

  while ($row = mysql_fetch_array($result)){ 
echo "$row[rpayment]<br>";
echo "
"; 
      } 
}

That queries the db to print all the rpayment (price) values, now I just need to add those values together.

drew010

$total = 0;

foreach ($_POST['cb'] as $value) { 
  $query = "SELECT rpayment from db WHERE dbnum = '$value'"; 
  $result = mysql_query($query); 
  $row    = mysql_fetch_row($result); //im guessing theres only 1 record for each id

  $total += $row[0];
}

GundamSV7

thnx a lot, that worked great.