SUM mysqli query returning array

Question

What I want is to add up all values in the points column These are stored as INT(4)

However its echoing Array when I try to display result

$pipq = mysqli_query($con,"SELECT `points` FROM `table` WHERE `result` !='2'");
 $pips = mysqli_fetch_assoc($pipq);
 $sum = 0;
 do {
 $sum += $pips[0];
 } while($pips = mysqli_fetch_assoc($pips));

Any help would be appreciated

rarely seen a do { } while()

madalinivascu
– madalinivascu

2017-11-07 10:04:37 +00:00
Commented Nov 7, 2017 at 10:04 — madalinivascu
– madalinivascu, Commented Nov 7, 2017 at 10:04

Death-is-the-real-truth · Accepted Answer · 2017-11-07 10:15:17Z

1

1.With SQL query Itself you can do like below:-

$pipq = mysqli_query($con,"SELECT SUM(`points`) as total_mark FROM `table` WHERE `result` !='2'");
$pips = mysqli_fetch_assoc($pipq);
echo $pips['total_mark'];

2.Your code will work also after below change:-

$pipq = mysqli_query($con,"SELECT `points` FROM `table` WHERE `result` !='2'");
$sum = 0;
while($pips = mysqli_fetch_assoc($pips)){ // use while only
  $sum += $pips['points']; // use column-name here
}
echo $sum;

Note:- 1st one is far-better than 2nd one. So use 1st one.

edited Nov 7, 2017 at 10:15

answered Nov 7, 2017 at 10:04

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

4 Comments

Aiyaz Khorajia Over a year ago

You can directly sum the points in mysql query like SELECT SUM(points) as total_points FROM table WHERE result !='2'

Death-is-the-real-truth Over a year ago

@AiyazKhorajia i am adding that meanwhile you said. Thanks anyway.

Chris Yates Over a year ago

Diamond ! Works perfectly .. will accept answer in 7 mins when system allows me to

Death-is-the-real-truth Over a year ago

@ChrisYates check my edited solution once. Glad to help you :):)

Collectives™ on Stack Overflow

SUM mysqli query returning array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related