gettting records

[php4me]

i am working on something that will allow me to get certain records for each season and career. The career one i have down pat, but can't seem to figure out the leaders for each category by sorting through the seasons.

my tables are like so

divisions

id
name
seasonid

player_stats

id
playerid
goals
assists
+++more stats columns
game_id
team_id
div_id
seasonid

players

id
lname
fname
teamid
position
+++more player stuff

schedule_scores

id
date
time
location
team1
team2
team1_div
team2_div
team1_score
team2_score
season

seasons

id
name
status

teams

id
name
division
+++bunch more team info

below is code i used to get most goals in career. now trying to get most goals in season.

any help or guidance appriciated 🙂

<?php


function Compare_stats($ar1, $ar2)
{
   if ($ar1['goals']<$ar2['goals'])
      return 1;
   else if ($ar1['goals']>$ar2['goals'])
      return -1;
   if ($ar1['lname']<$ar2['lname'])
      return -1;
   else if ($ar1['lname']>$ar2['lname'])
      return 1;
   if ($ar1['fname']>$ar2['fname'])
      return 1;
   else if ($ar1['fname']<$ar2['fname'])
      return -1;
   return 0;
}



//HOMEPAGE
function divstats($sid,$order) {

 include("config.php");

//LOAD THE HTML
$filename = $sport_dir."html/a.html";
$fd = fopen ($filename, "r");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);

    $open = mysql_connect($hostname,$user,$password);
    mysql_select_db("$db",$open);




//GET CURRENT SEASON



    if(!$sid) {
    	$sql_seasons_statement = "SELECT * FROM seasons WHERE status = '1'";
	$result_seasons = mysql_query("$sql_seasons_statement");
	$total_seasons = mysql_numrows($result_seasons);
	$open_season = mysql_result($result_seasons,0,"id");
	$open_season_name = mysql_result($result_seasons,0,"name");
} else {
	$sql_seasons_statement = "SELECT * FROM seasons WHERE id = '$sid'";
	$result_seasons = mysql_query("$sql_seasons_statement");
	$total_seasons = mysql_numrows($result_seasons);
	$open_season = mysql_result($result_seasons,0,"id");
	$open_season_name = mysql_result($result_seasons,0,"name");
}

if(!$sid) {
$sid = $open_season;
}

	//GET CURRENT DIVISION
$result_division2 = mysql_query("SELECT name FROM divisions WHERE id = '".$divid."'");
$divisionname2 = mysql_result($result_division2,0,"name");


//get player stats

$stats_sql = "SELECT * FROM player_stats,teams,players WHERE 
					teams.id = player_stats.team_id AND "
					."players.id = player_stats.playerid";



$result_stats = mysql_query("$stats_sql");
	if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
$statcount = mysql_numrows($result_stats);

//start point stats

            $sc = 0;

                            $p_array = Array();
			while($sc < $statcount) {
$playerid = mysql_result($result_stats,$sc,"players.id");



$p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$sc,"player_stats.goals");
$p_array[$playerid][fname] = mysql_result($result_stats,$sc,"players.fname");
$p_array[$playerid][lname] = mysql_result($result_stats,$sc,"players.lname");
$p_array[$playerid][team] = mysql_result($result_stats,$sc,"teams.name");
				//Added next 3 lines for showing links for players and teams 10-14-05 DJ
$p_array[$playerid][tid] = mysql_result($result_stats,$sc,"teams.id");
$p_array[$playerid][divid] = mysql_result($result_stats,$sc,"teams.division");
$p_array[$playerid][pid] = mysql_result($result_stats,$sc,"players.id");
				$sc++;
				}

uasort($p_array, 'Compare_stats');


           for($i=0; $i<5; $i++)
		   {
            list ($key, $value) = each ($p_array);
 $tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";	                


$p_stats .= "
	                <tr bgcolor=\"".$tbgcolor."\" align=\"center\">
<td width=\"50%\"><a class=\"table_text\" href=\"./?opt=viewplayer&pid=".$value["pid"]."&sid=".$sid."&tid=".$value["tid"]."&divid=".$value["divid"]."\">".$value["fname"]." ".$value["lname"]." </a></td>

<td width=\"30%\"><a class=\"table_text\" href=\"./?opt=viewteam&id=".$value["tid"]."&sid=".$sid."\">".$value["team"]."</a></td>

<td width=\"20%\" class=\"text8\"><font color=\"black\"> ".$value["goals"]."</font></td>
			                </tr>";
			     }

$contents = eregi_replace("<!--%ANNOUNCEMENTS%-->",$ann,$contents);
$contents = eregi_replace("<!--%LEAGUE_TITLE%-->",$league_name,$contents);
$contents = eregi_replace("<!--%TEAM_NAME%-->",$body_title,$contents);
$contents = eregi_replace("<!--%MENU%-->",$menu,$contents);
$contents = eregi_replace("<!--%GOALS%-->",$p_stats,$contents);
$contents = eregi_replace("<!--%GOALSSEASON%-->",$stats,$contents);
$contents = eregi_replace("<!--%PINFO%-->",$pinfo,$contents);
$contents = eregi_replace("<!--%DIVNAMER%-->",$divisionname2,$contents);
$contents = eregi_replace("<!--%SEASONBAR%-->",$sid,$contents);
$contents = eregi_replace("<!--%STATS1%-->",$topper1,$contents);

echo $contents;

}

?>