Lets Go Mets!
Welcome! PDF Print E-mail
Site News
Written by Tom Keenan   
Thursday, 03 February 2011 13:53
Welcome to LGM.me!  Currently, we are in the process of retooling the site a little bit and trying to figure out ways to make it better.  Feel free to explore it a bit or even register to gain access to the forum.
 
More Articles...
« StartPrev12345678910NextEnd »

Page 1 of 95

Mets News

This Day in Mets History

and EXTRACT(MONTH FROM GAME_DT) = '". $curMonth . "' and EXTRACT(DAY FROM GAME_DT) = '". $curDay ."' group by OPP Order by Team");
$outputTeams = "<table><tr><th>Team</th><th>W</td><th>L</td></tr>";
$outputStand = "<table><tr><th>Year</th><th>Team</th><th>Score</th><th>Boxscore</th>";
while($row = mysql_fetch_array($teamresult))
{
if ($shading==1)
{
$outputTeams .= "<tr><td>" . $row['Team'] . "</td><td>" . $row['W'] . "</td><td>" . $row['L'] ."</td></tr>";
$shading=0;
} else {
$outputTeams .= "<tr><td bgcolor='#cccccc'>" . $row['Team'] . "</td><td bgcolor='#cccccc'>" . $row['W'] . "</td><td bgcolor='#cccccc'>" . $row['L'] ."</td></tr>";
$shading=1;
}
}
$outputTeams .= "</table>";
while($row = mysql_fetch_array($result))
{
$pct = substr(number_format($row['PCT'],3),1,4);
if($row['HOMEAWAY'] == "H")
{
$HomeAway = $row['NAME_TEAM_TX'];
$HomeTeam = "NYN";
} else {
$HomeAway = "at " . $row['NAME_TEAM_TX'];
$HomeTeam = $row['OPP'];
}
if($row['W_L'] == "W")
{
if ($rowcount < 10)
{
$last10Win ++;
}
$allTimeWins ++;
if($row['HOMEAWAY'] == "H")
{
$allTimeHomeWin = $allTimeHomeWin + 1;
} else {
$allTimeRoadWin = $allTimeRoadWin + 1;
}
} else {
if ($rowcount < 10)
{
$last10Loss ++;
}
$allTimeLoss ++;
if($row['HOMEAWAY'] == "H")
{
$allTimeHomeLoss = $allTimeHomeLoss + 1;
} else {
$allTimeRoadLoss = $allTimeRoadLoss + 1;
}
}
$rowcount ++;
$Score = $row['METSRUNS'] . "-" . $row['OPPRUNS'];
$boxscoreURL = "http://www.baseball-reference.com/boxes/" . $HomeTeam . "/" . $row['GAME_ID'] . ".shtml";
$w = $row['W'];
$l = $row['L'];
if($rowcount < 11) {
if ($shading==1) {
$outputStand .= "<tr><td><b>" . $row['YEAR'] . "</b></td>";
$outputStand .= "<td>" . $HomeAway . "</td><td>" . $Score . "</td><td><a href='". $boxscoreURL . "' target='_blank'>Boxscore</a></td></tr>";
$shading=0;
} else {
$outputStand .= "<tr><td bgcolor='#cccccc'><b>" . $row['YEAR'] . "</b></td>";
$outputStand .= "<td bgcolor='#cccccc'>" . $HomeAway . "</td><td bgcolor='#cccccc'>" . $Score . "</td><td bgcolor='#cccccc'><a href='". $boxscoreURL . "' target='_blank'>Boxscore</a></td></tr>";
$shading=1;
}
}
}
$outputStand .= "</table>";
echo "<table><tr><td valign='top'>";
echo "<b>Mets record for " . date(M) . " " . date(d) . ":</b> " . $allTimeWins . " - " . $allTimeLoss ."<br />";
echo "<b>Mets record for " . date(M) . " " . date(d) . " at home:</b> " . $allTimeHomeWin . " - " . $allTimeHomeLoss ."<br />";
echo "<b>Mets record for " . date(M) . " " . date(d) . " on the road:</b> " . $allTimeRoadWin . " - " . $allTimeRoadLoss ."<br />";
echo "<b>Mets record for last 10 games on " . date(M) . " " . date(d) . ":</b> " . $last10Win . " - " . $last10Loss ."<br />";
echo $outputStand;
echo "</td><td valign='top'>";
echo $outputTeams;
echo "</td></tr></table>";
mysql_close($con);
?>
Mets record for Jan 28: 0 - 0
Mets record for Jan 28 at home: -
Mets record for Jan 28 on the road: 0 - 0
Mets record for last 10 games on Jan 28: -
YearTeamScoreBoxscore
Full List >>
TeamWL

LGM Forum Recent Replies

Mets Blogs