December 16, 2020
Home Run Leaders
“);
echo(“
“); $get_HR_leaders=$conn->query(“SELECT P.nameFirst, P.nameLast, P.finalGame, SUM(B.HR) AS Homers FROM `batting` B, `people` P WHERE B.playerID=P.playerID GROUP BY B.playerID ORDER BY Homers DESC LIMIT 500”); echo(“
“); echo(“ |
“); $get_active_HR_leaders=$conn->query(“SELECT P.nameFirst, P.nameLast, P.finalGame, SUM(B.HR) AS Homers FROM `batting` B, `people` P WHERE B.playerID=P.playerID AND (LEFT(P.finalGame,4)=’2019′ OR LEFT(P.finalGame,4)=’2018′) GROUP BY B.playerID ORDER BY Homers DESC LIMIT 500”); echo(“
“); echo(“ |
“);
?>
no comment until now