These are the $tmpteam Game Times, Opponents and Arena Locations

"; //select all games in the schedule for the team selected. $sql = "SELECT * from hc_schedule where hc_schedule.away_team_id=$frm_teamID OR hc_schedule.home_team_id=$frm_teamID order by hc_schedule.game_date ASC, hc_schedule.game_number ASC"; $sql_result = mysql_query($sql) OR DIE ("Couldn't execute schedule query."); while ($row = mysql_fetch_array($sql_result)) { $sql2 = "SELECT * FROM hc_teams where teamid = $row[away_team_id]"; $sql_result2 = mysql_query($sql2) OR DIE ("Couldn't lookup away team."); while ($row2 = mysql_fetch_array($sql_result2)) { $tmp_away_team = "$row2[teamname]"; } $sql2 = "SELECT * FROM hc_teams where teamid = $row[home_team_id]"; $sql_result2 = mysql_query($sql2) OR DIE ("Couldn't lookup home team."); while ($row2 = mysql_fetch_array($sql_result2)) { $tmp_home_team = "$row2[teamname]"; } print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "
Date (ymd) Game Time Rink Home Team Score Away Team Score
"; print "$row[game_date]"; print "$row[game_number]$row[game_time]$row[rink]$tmp_home_team$row[home_team_score]$tmp_away_team$row[away_team_score]
"; ?>