Simple array/add question

[karimali831]

Hey,

 

Can someone please fix my code below?

 

I simply want to add all values for $row[score1] in first if statement and add

all values for $row[score2] in second if statement and then add them together

to return final value

.

 

        while( $row = mysql_fetch_assoc($query)) {
           
   if($clanID==$row[clan1] && $row[score1] > $row[score2]) {	   
      $points[] = $row[score1];
           }	      
   if($clanID==$row[clan2] && $row[score1] < $row[score2]) {	   
      $points[] = $row[score2];
           }
   
        }

        return $points;

.

 

So lets say I echo the variables that I want added...

 

	   if($clanID==$row[clan1] && $row[score1] > $row[score2]) {	   
      $points[] = $row[score1];
      
      echo $row['score1']."<br>";
      
           }	      
   if($clanID==$row[clan2] && $row[score1] < $row[score2]) {	   
      $points[] = $row[score2];
      
      echo $row['score2']."<br>";
      
           }

 

On page it returns as:

 

11

16

14

 

Add it together is 41 and this is what I want the output to be.

 

Hope you understand

I appreciate any help!

 

P.S. I must be able to return final value OUTSIDE loop.

 

Thanks.

[Alexv]

I don't understand. Do you want only 41 to be your output or all values and then 41?

[karimali831]

When you add all the values it will be 41 so I just want the output to be 41 so it is like:

 

while() {

 

$row['col1'];

 

-- sum up all values in $row['col1']

 

}

[Alexv]

        $points = 0;
        while( $row = mysql_fetch_assoc($query)) {
           
   if($clanID==$row[clan1] && $row[score1] > $row[score2]) {	   
      $points += $row[score1];
           }	      
   if($clanID==$row[clan2] && $row[score1] < $row[score2]) {	   
      $points += $row[score2];
           }
   
        }

        return $points; 

 

That should return the sum of all values.

 

 

[karimali831]

        $points = 0;
        while( $row = mysql_fetch_assoc($query)) {
           
   if($clanID==$row[clan1] && $row[score1] > $row[score2]) {	   
      $points += $row[score1];
           }	      
   if($clanID==$row[clan2] && $row[score1] < $row[score2]) {	   
      $points += $row[score2];
           }
   
        }

        return $points; 

 

That should return the sum of all values.

 

 

 

Brilliant thanks very much!

 

I thought it didn't work because $points = 0; wasn't declared above loop,

and was getting all crazy values. why must this be done?

[Alexv]

Just good coding practice. You can do it without that line but if you turn on all errors php will give a Notice about an undefined variable $points. It will still work but i just like it to be by the book

[Pikachu2000]

It should also throw a ton of "undefined constant" notices, too. None of the string type array indices are quoted in the OP's code.