hey everyone,
i'm looking on how i can seperate a players stats from the same season. in my database it shows them as being seperate, but the code in which I use combines the totals for the same team.
here is alittle example of my code
$result_stats = mysql_query("SELECT * FROM player_stats WHERE playerid = '".mysql_result($result_pi,$i,"id")."' AND seasonid = '".$sid."'");
$playerid = mysql_result($result_pi,$i,"id");
or if you need alittle more info go here
http://msnhockey.com/mods/help.txt
i want it to display like this
player team goals assists points and so on
m.carter TOR 12 12 24
Van 12 12 24
total 24 24 48
any help is appriciated
thganks
mike