How to add values from mysql_fetch_array?

Question

Here is my code but it displays two different sum of values. I have total with per row and it has 2 value 100 and 200 . it displays 100 and 200 seperately. But i want the sum of 100 and 200 . sum= 300 how could i do it?

$result2 = mysql_query("select * from price  where dom='$cat'",$db);
while ($myrow2 = mysql_fetch_array($result2))
{
    echo $myrow2["totalwithper"];
}

here is my table structure

CREATE TABLE `price` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `dom` varchar(255) COLLATE utf8_bin NOT NULL,
  `etiket` varchar(255) COLLATE utf8_bin NOT NULL,
  `pricestandart` int(5) NOT NULL,
  `number` int(5) NOT NULL,
  `totalunper` int(5) NOT NULL,
  `discount` int(5) NOT NULL,
  `totalwithper` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=20 ;

--
-- Dumping data for table `price`
--

INSERT INTO `price` (`id`, `dom`, `etiket`, `pricestandart`, `number`, `totalunper`, `discount`, `totalwithper`) VALUES
(18, 'Alten Group', 'flayer', 100, 1, 100, 10, 90),
(19, 'Alten Group', 'logo', 100, 2, 200, 15, 170);

Marco A. · Accepted Answer · 2014-01-23 20:13:03Z

1

I have spent the last couple of days trying to make the array_sum() function work and it would print out every number but wouldn't add them together. But with this code it finally worked for me TY.

 $sum=0;
 $result2 = mysql_query ("select totalwithper from price  where dom='$cat'",$db);
 while($myrow2=mysql_fetch_array($result2))
 {
    $sum=$sum+ $myrow2["totalwithper"];
 }

 echo "sum : $sum";

edited Jan 23, 2014 at 20:13

Marco A.

43.8k27 gold badges146 silver badges263 bronze badges

answered Jan 23, 2014 at 19:55

Trevor

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

pckabeer · Accepted Answer · 2012-08-08 13:06:29Z

0

Try this:

  $result2 = mysql_query ("select sum(totalwithper) from price  where dom='$cat'",$db);
  $myrow2= mysql_fetch_array($result2);
  do{
     echo $myrow2["totalwithper"];
    }
    while($myrow2=mysql_fetch_array($result2));

a small rewrite to your code :

 $result2 = mysql_query ("select sum(totalwithper) from price  where dom='$cat'",$db);
 while($myrow2=mysql_fetch_array($result2))
        {
         echo $myrow2["totalwithper"];
        }

sum by loop

 $sum=0;
 $result2 = mysql_query ("select totalwithper from price  where dom='$cat'",$db);
 while($myrow2=mysql_fetch_array($result2))
        {
         $sum=$sum+ $myrow2["totalwithper"];
        }

 echo "sum : $sum";

In $sum you will get the sum.

edited Aug 8, 2012 at 13:06

answered Aug 8, 2012 at 12:05

pckabeer

6946 silver badges27 bronze badges

7 Comments

Jocelyn Over a year ago

If you fix the indenting and remove the useless blank lines it will look even nicer :-)

Ali Shikhiyev Over a year ago

thank all of you But now it doesnt give any result. do u have any idea? or how could use loop get all values from fetch array then adding up them? what you think?

pckabeer Over a year ago

ali can you share your table structure

Ali Shikhiyev Over a year ago

i posted table structure at the top of page where i asked question.

pckabeer Over a year ago

are you looking for the sum of totalunper

|

VolkerK · Accepted Answer · 2012-08-08 12:03:55Z

0

SELECT Sum(totalwithper) FROM price  WHERE ...

see:

answered Aug 8, 2012 at 12:03

VolkerK

96.3k20 gold badges169 silver badges232 bronze badges

Comments

Parvin Gasimzade · Accepted Answer · 2012-08-08 12:13:14Z

0

Use

$result2 = mysql_query ("select sum(totalwithper) from price  where dom='$cat'",$db);

edited Aug 8, 2012 at 12:13

Parvin Gasimzade

26.1k8 gold badges58 silver badges83 bronze badges

answered Aug 8, 2012 at 12:05

Vamsi

8731 gold badge8 silver badges16 bronze badges

1 Comment

Vamsi Over a year ago

@parvin: in quesion 'Ali Shikhiyev' has mentioned as total with per row

Collectives™ on Stack Overflow

How to add values from mysql_fetch_array?

4 Answers 4

Comments

7 Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

7 Comments

Comments

1 Comment

Related