Complex Arrays ? ? ?

DeadFly

OK, heres what I'm trying to do.
I'm making a Conference standings listing for the NHL, based on points BUT in the NHL they have a weird way fo doing standings.

3 Divisions per Conference . . . The top team in each division gets pooled and they get the first 3 positions. After the top team from every division is selected then the rest of the conference gets pooled and then sorted . . . all based on points.

IE:
Team - Division - Points
New Jersey-0-12
New York-0-9
Toronto-1-15
Ottawa-1-12
Montreal-1-13
Carolina-2-10
Florida-2-8

Would turn out the results :

Place - Team - Points
1-Toronto-15
2-New Jersey-12
3-Carolina-10
4-Montreal-13
5-Ottawa-12
6-New York-9
7-Florida-8

Notice how Montreal has more points than Carolina, but Montreal wasnt top in their Division.

Does anybody have any ideas on how would be the best way to attack this beast ?

Thanks in advance

DeadFly

no help ?
🙁

DXL

maybe, u could rephrase that?

it was a bit confusing to me, since i also don't really know much about sports

also, what you want it to say with the divisions...that is just...uhh, could i say "flicted" and get away with it?

DeadFly

Well I THINK I figured it out.
Maybe someone knows an easier way to write this code . . . ?

<?
/// Top team from each division gets ordered & listed
for ($n=0;$n<3;$n++) {
	$query="SELECT 
				team_id,
				team_city,
				team_symbol,
				ABS((team_season_w * $_nhl_Config[13])+
				(team_season_t * $_nhl_Config[15])+
				(team_season_otl * $_nhl_Config[14])) as points 
			FROM nhl_teams 
			WHERE team_div=$n 
			ORDER BY points DESC";
	$result=@mysql_query($query); ///// Run the query
	$num=mysql_num_rows($result); ///// How many users
	$row = mysql_fetch_array($result, MYSQL_NUM);
	$TopEastID[$n]=$row[0];
	$TopEast[$row[3]]='» <a href="'.intlink("view_team","hub=nhl&team=$row[0]").'">'.stripslashes($row[1].' '.$row[2]).'</a></td><td align="right">'.$row[3].'</td></tr>';			
	mysql_free_result ($result); ///// Free up the resources.						
}
krsort($TopEast);
$x=0;
while (list ($key, $val) = each ($TopEast)) {
	$x++;
    echo '<tr><td><b>'.$x.'</b> '.$val;
}
/// All other teams get ordered & listed
$query="SELECT
			team_id,
			team_city,
			team_symbol,
			team_div,
			ABS((team_season_w * $_nhl_Config[13])+
			(team_season_t * $_nhl_Config[15])+
			(team_season_otl * $_nhl_Config[14])) as points						
		FROM nhl_teams 
		WHERE team_conf=0 AND team_id!=$TopEastID[0] AND team_id!=$TopEastID[1] AND team_id!=$TopEastID[2]
		ORDER BY points DESC, team_season_w DESC, team_season_t DESC, team_season_otl DESC";
$result=@mysql_query($query); ///// Run the query
$n=3;
while($row=mysql_fetch_array($result, MYSQL_NUM)){
	$n++;
	if($n==9) {echo '<tr><td colspan="2"><hr width="100%" size="1" id="mainhr"></td></tr>';}				
	if ($n<9){
		echo '<tr><td><b>'.$n.'</b> » <a href="'.intlink("view_team","hub=nhl&team=$row[0]").'">'.stripslashes($row[1].' '.$row[2]).'</a></td><td align="right">'.$row[4].'</td></tr>';
	}else{
		echo '<tr><td>» <a href="'.intlink("view_team","hub=nhl&team=$row[0]").'">'.stripslashes($row[1].' '.$row[2]).'</a></td><td align="right">'.$row[4].'</td></tr>';
	}			
}
?>