On my stats page for showing players stats on their respective teams the stats show up but all the stats are multiplied by the number of games they played.
here is some of the main code as php file is big as it displays alot of different info
any pointers are appriciated
if i change the stuff i have in red i get different results, but not the correct ones
//PLAYER STATS
[COLOR="Red"] $stats_sql = "SELECT * FROM players, player_stats "
. "WHERE player_stats.team_id = '".$id."' "
. "AND player_stats.playerid = players.id "
. "AND player_stats.seasonid = '".$sid."' ";
$result_pi = mysql_query("$stats_sql ");
$total_pi = mysql_numrows($result_pi);[/COLOR]
$i = 0;
$stats .= "
<table width=\"96%\" bgcolor=\"$h_color\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" align=\"center\">
<tr>
<td bgcolor=\"#ffffff\">
<table border=\"0\" width=\"100%\" cellpadding=\"2\" bordercolor=\"$h_color\" cellspacing=\"1\">
<tr align=\"center\" bgcolor=\"$h_color\">
<td colspan=\"12\" class=\"table_header\"> <font color=\"$a_color\"> PLAYER STATS</font></td>
</tr>
<tr bgcolor=\"#dfdfdf\" align=\"center\">
<td class=\"table_header\"><!--%cc_unf%--></td>
<td class=\"table_header\"><!--%cc_pname%--></td>
<td class=\"table_header\">GP</td>
<td class='table_header'><a href='./?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=goals'><u>G</a></u></td>
<td class='table_header'><a href='./?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=assists'><u>A</a></u></td>
<td class='table_header'><a href='./?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=pts'><u>PTS</a></u></td>";
if($user_xtra1 == 1){
$stats .= "<td class=\"table_header\"><a href='?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=xtra1'><u>$user_x1titles</a></u></td>";
}
if($user_xtra2 == 1){
$stats .= "<td class=\"table_header\"><a href='?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=xtra2'><u>$user_x2titles</a></u></td>";
}
if($user_xtra3 == 1){
$stats .= "<td class=\"table_header\"><a href='?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=xtra3'><u>$user_x3titles</a></u></td>";
}
if($user_xtra4 == 1){
$stats .= "<td class=\"table_header\"><a href='?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=xtra4'><u>$user_x4titles</a></u></td>";
}
if($user_xtra5 == 1){
$stats .= "<td class=\"table_header\"><a href='?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=xtra5'><u>$user_x5titles</a></u></td>";
}
$stats .= "
<td class=\"table_header\"><a href='?opt=viewteam&id=$id&divid=$divid&sid=$sid&order=pim'><u>PIM</a></u></td>
</tr>";
$p_array = Array();
while($i < $total_pi) {
//GET STAT INFORMATION
[COLOR="Red"]$result_stats = mysql_query("SELECT * FROM player_stats WHERE playerid = '".mysql_result($result_pi,$i,"id")."' AND seasonid = '".$sid."' AND team_id = '".$id."' ");[/COLOR] $playerid = mysql_result($result_pi,$i,"id");
$result_num = mysql_numrows($result_stats);
if($result_num != 0){
$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][xtra5] = $p_array[$playerid][xtra5] + mysql_result($result_stats,$ps,"xtra5");
$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][id] = mysql_result($result_pi,$i,"id");
$p_array[$playerid][number] = mysql_result($result_pi,$i,"number");
$p_array[$playerid][position] = mysql_result($result_pi,$i,"position");
$p_array[$playerid][captain] = mysql_result($result_pi,$i,"captain");
//ROW COLOR
$tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";
} else {
$p_array[$playerid][goals] = '0';
$p_array[$playerid][assists] = '0';
$p_array[$playerid][goalsa] = '0';
$p_array[$playerid][shotsa] = '0';
$p_array[$playerid][minutes] = '0';
$p_array[$playerid][xtra1] = '0';
$p_array[$playerid][xtra2] = '0';
$p_array[$playerid][xtra3] = '0';
$p_array[$playerid][xtra4] = '0';
$p_array[$playerid][xtra5] = '0';
$p_array[$playerid][played] = '0';
$p_array[$playerid][gp] = '0';
$p_array[$playerid][fname] = mysql_result($result_pi,$i,"fname");
$p_array[$playerid][lname] = mysql_result($result_pi,$i,"lname");
$p_array[$playerid][id] = mysql_result($result_pi,$i,"id");
$p_array[$playerid][number] = mysql_result($result_pi,$i,"number");
$p_array[$playerid][pts] = '0';
$p_array[$playerid][captain] = mysql_result($result_pi,$i,"captain");
}
$i++;
}
