Add multiple values to one variable in PHP while loop (adding to variables that haven't been declared)

Question

Im looking for a way to add up all data for "awayscore" returned from a sql query in a while loop and add it to a variable. After the loop the total for awayscore needs to be printed on screen. Part of my code looks like this, it displays all match results from 2009 - present for two selected teams in a table.

while($row = mysql_fetch_array($query)){
    $gamesplayed ++;            
        echo'<tr>';
        echo '<td>'.$row['gamedate'].'</td>';
        echo '<td>'.$row['hometeam'].'</td>';
        echo'<td>'.$row['awayteam'].'</td>';
            echo'<td>'.$row['homescore'].'</td>';
                echo'<td>'.$row['awayscore'].'</td>';
                if($row['homescore'] > $row['awayscore']){
                    $team1wins++;
                            echo'<td style="background-color:yellow">'.$row['hometeam'].'</td>';    
                }

                else if($row['homescore'] < $row['awayscore'])
                {$team2wins++;
                     echo'<td>'.$row['awayteam'].'</td>';
                }

        echo'</tr>';                

    }

I tried to add up the totals for "homescore" and "awayscore" by adding the following statment in the while loop

$totAwayPoints += $row['awayscore'];
$totHomePoints += $row['homescore'];

However when I print the two variables on screen after the loop I get the following error: undefined variable

Any idea what I am doing wrong, or any suggest what I can do to improve this will be greatly appreciated.

Could you show the value of your $query variable? Perhaps the sql statement? — remedy.
– remedy., Commented Feb 2, 2014 at 4:47
My first question would be: is the while loop even iterating? — rcorrie
– rcorrie, Commented Feb 2, 2014 at 4:49
I took the code out of the while loop after I received the error. I only added it here for reference for what I tried to do. All columns is type varchar in my DB — Marilee
– Marilee, Commented Feb 2, 2014 at 4:50
You don't seem to have gone through some of the most basic steps of debugging... print out the variables in question INSIDE the loop and see where it's falling apart. — rcorrie
– rcorrie, Commented Feb 2, 2014 at 4:50

m59 · Accepted Answer · 2014-02-02 04:49:31Z

4

Your question seems to be lacking some of the relevant code, but the issue to me sounds like you failed to initialize the variables in advance, so you are unable to add to them.

Declare the variables before the loop:

$totAwayPoints = 0;
$totHomePoints = 0;

while( //etc

and then add to them within the loop.

I feel confident this is the problem, as you wouldn't be getting a message about undefined variables if you had created them in advance.

answered Feb 2, 2014 at 4:49

m59

43.9k14 gold badges122 silver badges139 bronze badges

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

Collectives™ on Stack Overflow

Add multiple values to one variable in PHP while loop (adding to variables that haven't been declared)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related