Hockey Players With More Than 20 PIM
$sql = "SELECT
AVG(G) AS AverageGoals,
AVG(PTS) AS AveragePoints,
AVG(PIM) AS AveragePenaltyMinutes
FROM dent_hockey.nhlstats
WHERE G >= 30 AND PIM > 20"
$results = $mysql->query($sql);
if(!$results) {
echo "SQL error: ". $mysql->error . " running query
" . $sql . "
";
exit();
} else {
// embed sql into comment block of webpage (right-click View Page Source to view)
echo "";
}
?>
Average Penalty Minutes
Warning: Array to string conversion in /home/erinmcle/public_html/idsn530/07/hockeystats.php on line 78
Array
Average Goals Minutes
Warning: Array to string conversion in /home/erinmcle/public_html/idsn530/07/hockeystats.php on line 82
Array
Average Points Minutes
Warning: Array to string conversion in /home/erinmcle/public_html/idsn530/07/hockeystats.php on line 85
Array
Toughest NHL scorers