[RESOLVED] php code doubling output..

[msnhockey]

i am having some trouble with my code doubling. it keeps doubling my table header stuff and my career totals line..

this is a lot of code, but hopefully someone can see why its doubling...

	//PLAYER STATS

        $result_pi = mysql_query("SELECT * FROM players WHERE id = '".$pid."'");
        $total_pi = mysql_numrows($result_pi);
        $i = 0;















	$p_array = Array();

        while($i < $total_pi) {

	        //GET STAT INFORMATION
        	$result_stats = mysql_query("SELECT * FROM player_stats WHERE playerid = '".$pid."' AND seasonid = '".$sid."'");


    if(!$result_stats) {
                $stats2 .= "<tr><td class=\"body_text\" align=\"center\" colspan=\"9\"
                        bgcolor=\"#efefef\"><!--%cc_nostats%--></td></tr>";
    }  else {



		$playerid = mysql_result($result_pi,$i,"id");

        	$ps = 0;

		while($ps < mysql_numrows($result_stats)) {

			$p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$ps,"goals");
			$p_array[$playerid][assists] = $p_array[$playerid][assists] + mysql_result($result_stats,$ps,"assists");
			$p_array[$playerid][goalsa] = $p_array[$playerid][goalsa] + mysql_result($result_stats,$ps,"goalsa");
			$p_array[$playerid][shotsa] = $p_array[$playerid][shotsa] + mysql_result($result_stats,$ps,"shotsa");
			$p_array[$playerid][minutes] = $p_array[$playerid][minutes] + mysql_result($result_stats,$ps,"minutes");
			$p_array[$playerid][xtra1] = $p_array[$playerid][xtra1] + mysql_result($result_stats,$ps,"xtra1");
			$p_array[$playerid][xtra2] = $p_array[$playerid][xtra2] + mysql_result($result_stats,$ps,"xtra2");
			$p_array[$playerid][xtra3] = $p_array[$playerid][xtra3] + mysql_result($result_stats,$ps,"xtra3");
			$p_array[$playerid][xtra4] = $p_array[$playerid][xtra4] + mysql_result($result_stats,$ps,"xtra4");
			$p_array[$playerid][played] = $p_array[$playerid][played] + mysql_result($result_stats,$ps,"played");
			$p_array[$playerid][gp] = $p_array[$playerid][gp] + 1;

			$ps++;
		}
		$p_array[$playerid][pts] = $p_array[$playerid][goals] + $p_array[$playerid][assists];
		$p_array[$playerid][fname] = mysql_result($result_pi,$i,"fname");
		$p_array[$playerid][lname] = mysql_result($result_pi,$i,"lname");
		$p_array[$playerid][number] = mysql_result($result_pi,$i,"number");
		$p_array[$playerid][position] = mysql_result($result_pi,$i,"position");



                //ROW COLOR
   $si = 0;
 $tbgcolor = is_int($si / 2)?"#efefef":"#999999";
	                $i++;
	        } 





	$si = 0;
        while (list ($key, $value) = each ($p_array)) {

                $stats2 .= "

<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">

<td bgcolor=\"#000000\">















<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"1\">



<tr bgcolor=\"".$tbgcolor."\" align=\"center\">
<td width=\"20%\" class=\"table_text\">".$seasonname." </td>
<td width=\"7%\" class=\"table_text\">".$value["goals"]."</td>
<td width=\"7%\" class=\"table_text\">".$value["assists"]."</td>
<td width=\"7%\" class=\"table_text\" bgcolor=\"#dfdfdf\">".$value["pts"]."</td>";

                if($user_xtra1 == "1"){
$stats2 .= "<td width=\"7%\" class=\"table_text\">".$value["xtra1"]."</td>";
	        	}
	                if($user_xtra2 == "1"){
$stats2 .= "<td width=\"7%\" class=\"table_text\">".$value["xtra2"]."</td>";
	        	}
	                if($user_xtra3 == "1"){
$stats2 .= "<td width=\"7%\" class=\"table_text\">".$value["xtra3"]."</td>";
	        	}
	                if($user_xtra4 == "1"){
$stats2 .= "<td width=\"7%\" class=\"table_text\">".$value["xtra4"]."</td>";
	        	}



                $stats2 .= "
                <td width=\"7%\" class=\"table_text\">".$value["minutes"]."</td>
                <td width=\"7%\" class=\"table_text\">".$value["played"]."</td>


                </tr>";


        }
        }




$stats2 .= "</td></table></tr>";
}

$s_num++;
}