Adding inside a while loop php

Question

I have a script that pulls values from a MySQL database and puts into into a variable. Each time it iterates, it pulls a new value. I want to add these values together. Here's what I have:

while ($row = mysql_fetch_array( $result )) {

$getvalue = mysql_query("SELECT value FROM pointvalues WHERE code = '$row[code]'")or die(mysql_error()); 
$rowcode1 = mysql_fetch_array($getvalue);
$finalValue = $rowcode1["value"];
}

I want to keep adding $finalValue to itself.

There is a += operator for that. But it's quicker to ask your RDBMS to do it. — BadZen
– BadZen, Commented Sep 17, 2014 at 1:43

Marty · Accepted Answer · 2014-09-17 01:45:42Z

4

I recommend saving yourself all that work and simply changing your query to:

SELECT SUM(value) FROM pointvalues WHERE code = x

Reference: SUM

answered Sep 17, 2014 at 1:45

Marty

39.5k19 gold badges97 silver badges164 bronze badges

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

1 Comment

Jim McDermott Over a year ago

When I do this, I get "Resource id #7Resource id #8." Any idea?

Collectives™ on Stack Overflow

Adding inside a while loop php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related