Array not displaying variable

[eaglesfan17]

I have some code that looks like this :

 $query = "SELECT team, wins, loses, ties, pts_for, pts_agst
         FROM standings
         WHERE league_id='$league_id'
         AND season='$season'
         AND team IN ('$team1', '$team2')";

$res = mysql_query($query,$db);

while (list($team, $wins, $loses, $ties, $pts_for,  $pts_agst ) = mysql_fetch_row($res)) {

   ## store data in an array
   $results['Record'][$team] = $wins . '-' . $loses . '-' . $ties;
   $results['Points for'][$team] = $pts_for;
   $results['Points against'][$team] = $pts_agst;
}


echo "<table><tr><td><table cellspacing=0 class=border cellpadding=5><tr><th colspan=3>Offensive Matchup</th></tr>";



foreach ($results as $stat => $teamdata) {

  echo '<tr><td width=80>', $stat , '</td><td width=50>', $teamdata[$team1], '</td><td>', $teamdata[$team2], '</td></tr>';

}
       

That code works just fine...as you can see here: http://www.pmlfootball.net/matchup2.php?team1=Eagles&team2=Bears

My next section of code is what's giving me my problems:

  $query = "SELECT passing_player, team, sum(passing_cmp) as passing_cmp, sum(passing_att) as passing_att, sum(passing_yds) as passing_yds, sum(passing_td) as passing_td 
		 FROM game_passing, game_summary
         WHERE game_summary.game_id=game_passing.game_id
		 AND league_id='$league_id'
         AND season='$season'
         AND team IN ('$team1', '$team2')
		 GROUP BY passing_player";

$res=mysql_query($mysql_query,$db);

while (list($passing_yds, $passing_td, $passing_int, $passing_att) = mysql_fetch_row($res)) {

   ## store data in an array
   $passing_results['Passing Yds'][$team] = $passing_yds;
   $passing_results['Passing Tds'][$team] = $passing_td;
   $passing_results['Passing Ints'][$team] = $passing_int;
}


## At end, print the array in columns


foreach ($passing_results as $passing_stat => $teamdata_passing) {

  echo '<tr><td width=80>', $passing_stat , '</td><td width=50>', $teamdata_passing[$team1], '</td><td>', $teamdata_passing[$team2], '</td></tr>';

}

If you look at my webpage, you can see that the fields 'Passing Yds, Passing Tds, and Passing Ints' show up just fine, but the actual data does not appear....Any idea what's going wrong?

[toplay]

Your list() variables, don't match the columns being retrieved in your SELECT SQL.

[eaglesfan17]

Do you mean that $passing_yds is not equal to "sum(passing_yds) as passing_yds" from my query? Should i change $passing_yds to $sum(passing_yds) as $passing_yds"??

[toplay]

You are retrieving six columns in your SELECT and you only have four variables specified in the list(). So, change it to this:

list( , , $passing_yds, $passing_td, $passing_int, $passing_att)

to skip over passing_player and team, or specify two more variables:

list($passing_player, $team, $passing_yds, $passing_td, $passing_int, $passing_att)

hth.

🙂

[eaglesfan17]

Did what you said...Same problem...

$query = "SELECT team, sum( passing_cmp ) AS passing_cmp, sum( passing_att ) AS passing_att, sum( passing_yds ) AS passing_yds, sum( passing_td ) AS passing_td, sum( passing_int ) as passing_int
		FROM game_passing, game_summary
		WHERE game_summary.game_id = game_passing.game_id
		AND league_id =1
		AND season = 2006
		AND team IN ('$team1', '$team2')
		GROUP BY team";

$res=mysql_query($mysql_query,$db);

while (list( $team, $passing_cmp, $passing_att, $passing_yds, $passing_td, $passing_int)  = mysql_fetch_row($res)) {

   ## store data in an array
   $passing_results['Passing Completions'][$team] = $passing_cmp;
   $passing_results['Passing Attempts'][$team] = $passing_att;
   $passing_results['Passing Yds'][$team] = $passing_yds;
   $passing_results['Passing TD'][$team] = $passing_td;
   $passing_results['Passing INT'][$team] = $passing_int;
}


## At end, print the array in columns


foreach ($passing_results as $passing_stat => $teamdata_passing) {

  echo '<tr><td width=80>', $passing_stat , '</td><td width=50>', $teamdata_passing[$team1], '</td><td>', $teamdata_passing[$team2], '</td></tr>';

}

[toplay]

Well, start by putting MySQL error check after the query and before the fetch.

MySQL data retrieval code examples with error checking:
http://www.phpbuilder.com/board/showpost.php?p=10648003&postcount=4

Also, the use of "$teamdata_passing[$team1]" and "$teamdata_passing[$team2]" is assuming that there will be data returned for both teams. I'm sure you know that it probably will, but it's good coding practice not to assume that. You can use isSet() to make sure there is a value for that team before trying to display it.

Start putting displays (echo/print) at strategic places within your code to help yourself debug this.

[eaglesfan17]

Found it...

    $res=mysql_query($mysql_query,$db); 

"($mysql_query" needed to be changed to "($query"

So simple...Thanks for your help on my first error toplay. Also, I will definetly take your error handling suggestions into consideration as I am extremely new with PHP/MySQL and that would be handy.