1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| <?php
$query_limit_GetTop6 = sprintf("SELECT goalies.Team, proteam.Abbre, SUM(goaliestats.ProGP) as ProGP, SUM(goaliestats.ProStartGoaler) as ProStartGoaler, (SUM(goaliestats.ProGA)/SUM(goaliestats.ProMinPlay)) as Test6 ,goaliestats.Name, SUM(goaliestats.ProW) AS ProW, SUM(goaliestats.ProL) AS ProL, SUM(goaliestats.ProOTL) AS ProOTL, SUM(goaliestats.ProSA ) AS ProSA, SUM(goaliestats.ProGA ) AS ProGA, SUM(goaliestats.ProMinPlay ) AS ProMinPlay, SUM( goaliestats.ProShutouts) AS ProShutouts , goalies.Number
FROM goaliestats, goalies, proteam
WHERE goaliestats.Season_ID=%s
AND proteam.Number=goalies.Team
AND goalies.Name = goaliestats.Name
AND ProGP > 0
GROUP BY goaliestats.Name
ORDER BY Test6 asc , ProW DESC LIMIT 0,15",$ID_GetSeason);
$GetTop6 = mysql_query($query_limit_GetTop6, $connection) or die(mysql_error());
$row_GetTop6 = mysql_fetch_assoc($GetTop6);
$i=0;
do {
$i=$i+1;
?>
<tr>
<td align="center"><?php echo $i;?>.</td>
<td><a href="goalie.php?player=<?php echo $row_GetTop6['Number']; ?>"><?php echo $row_GetTop6['Name'];?></a></td>
<td align="center"><a href="pro_stats.php?team=<?php echo $row_GetTop6['Team']; ?>"><?php echo $row_GetTop6['Abbre'];?></a></td>
<td align="center"><?php echo $row_GetTop6['ProGP'];?></td>
<td align="center"><?php echo $row_GetTop6['ProStartGoaler'];?></td>
<td align="center"><?php echo $row_GetTop6['ProW'];?></td>
<td align="center"><?php echo $row_GetTop6['ProL'];?></td>
<td align="center"><?php echo $row_GetTop6['ProOTL'];?></td>
<td align="center" style="font-weight:bolder;font-size: 120%;"><?php if ($row_GetTop6['ProMinPlay'] > 0){ echo number_format(($row_GetTop6['ProGA'] / minutes($row_GetTop6['ProMinPlay']))*60,2); } else { echo "0"; } ?></td>
<td align="center"><?php if ($row_GetTop6['ProMinPlay'] > 0){ echo number_format(($row_GetTop6['ProSA'] - $row_GetTop6['ProGA']) / $row_GetTop6['ProSA'],3); } else { echo "0"; } ?></td>
<td align="center"><?php echo $row_GetTop6['ProShutouts'];?></td>
<td align="center"><?php echo $row_GetTop6['ProSA'];?></td>
<td align="center"><?php echo $row_GetTop6['ProGA'];?></td>
<td align="center"><?php echo minutes ($row_GetTop6['ProMinPlay']);?></td>
</tr>
<?php } while ($row_GetTop6 = mysql_fetch_assoc($GetTop6)); ?>
</tbody>
</table> |
Partager