While loop not indexing properly

[rprincejr]

I am having a problem with a while loop. All information comes out correctly except when it should index the team_id it doesnt. I cannot figure it out. I even tried 2 left joins and got the same thing. When the loop gets its info from the above query, it does everything properly except the team_id. It has to be something simple. Any help would be much appreciated.

       $query = mysql_query("SELECT r.sched_id, r.team_id,
                MAX(r.results_bigfish) AS bigfish,
                s.date_m AS month, s.date_d AS day, s.date_y AS year
                FROM ".$prefix."_classic_results r
                LEFT JOIN ".$prefix."_classic_schedules s ON r.sched_id = s.sched_id
                GROUP BY r.sched_id
                ORDER BY day");

   while($row = $db->sql_fetchrow($query)) {
            $query2 = mysql_query("SELECT team_id,
            partner1_firstname, partner1_lastname,
            partner2_firstname, partner2_lastname
            FROM ".$prefix."_classic_teams
            WHERE team_id = $row[team_id]");
            list($team_id, $partner1_firstname, $partner1_lastname, $partner2_firstname, $partner2_lastname) = $db->sql_fetchrow($query2);
            echo "<td width=\"50%\" align=\"center\"><B>Sched ID: $row[sched_id]<br>$row[month]-$row[day]-$row[year]<br>$partner1_firstname&nbsp;$partner1_lastname&nbsp;/&nbsp;$partner2_firstname&nbsp;$partner2_lastname<br>Big Fish - $row[bigfish] lbs.</B></td>";
   }