hey all,
working on something to get just goal scorers of each game... the code i have brings up all players for each team of that game. i am looking at making it so that just the goal scores come up.
ie: Crosby(2), Malkin, Gonchar, Letang(3)
If the player scores only one goal then just the name appears and more than 1 then how many in brackets.
here is what i have so far
<?
include("../../../config.php");
$open = mysql_connect($hostname,$user,$password);
mysql_select_db("$db",$open);
?>
<html>
<head>
<title>Game Details / Stats</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../../../includes/leaguestyle.css">
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function printWindow() {
bV = parseInt(navigator.appVersion);
if (bV >= 4) window.print();
}
// End -->
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="10" marginwidth="0" marginheight="0">
<?
//VARIABLES PASSED
$thisdiv = $tdiv;
//GET DIVISION NAME
$result_dn = mysql_query("SELECT id,name FROM divisions WHERE id = '".$thisdiv."'");
$thisdiv_name = mysql_result($result_dn,0,"name");
//GAME INFORMATION
$result_gm = mysql_query("SELECT * FROM schedule_scores WHERE id = '".$id."'");
$gm_team1 = mysql_result($result_gm,0,"team1");
if(eregi("l-",$gm_team1)) {
$gm_team1 = eregi_replace("l-","",$gm_team1);
$result_t1 = mysql_query("SELECT * FROM locations WHERE id = '".$gm_team1."'");
$t1_name = mysql_result($result_t1,0,"name");
} else {
$result_t1 = mysql_query("SELECT * FROM teams WHERE id = '".$gm_team1."'");
$t1_name = mysql_result($result_t1,0,"name");
}
$gm_team2 = mysql_result($result_gm,0,"team2");
if(eregi("l-",$gm_team2)) {
$gm_team2 = eregi_replace("l-","",$gm_team2);
$result_t2 = mysql_query("SELECT * FROM locations WHERE id = '".$gm_team2."'");
$t2_name = mysql_result($result_t2,0,"name");
} else {
$result_t2 = mysql_query("SELECT * FROM teams WHERE id = '".$gm_team2."'");
$t2_name = mysql_result($result_t2,0,"name");
}
$gm_team1_score = mysql_result($result_gm,0,"team1_score");
$gm_team2_score = mysql_result($result_gm,0,"team2_score");
//PLAYER STATS FOR HOME TEAM
$result_pi = mysql_query("SELECT * FROM players WHERE teamid = '".$gm_team2."' AND position != 'G' AND registered = '1' ORDER BY lname");
$total_pi = mysql_numrows($result_pi);
$i = 0;
while($i < $total_pi) {
//ROW COLOR
$pid = mysql_result($result_pi,$i,"id");
//GET STAT INFO
$result_ps = mysql_query("SELECT * FROM player_stats WHERE playerid = '".$pid."' AND game_id = '".$id."'");
$goals = mysql_result($result_ps,0,"goals");
$stats .= "
<tr>
<td class=\"table_text\">".mysql_result($result_pi,$i,"lname")." </td>
<td class=\"table_text\">($goals),</td> ";
$i++;
unset($result_ps);
}
$stats .= "</table></td>";
echo $stats;
?>
</body>
</html>
