MySQL

Select rows for the current day and month

YearEvent
1741 Prussian forces took Olmutz Czechoslovakia
1825 1st public railroad using steam locomotive completed in England
1831 Darwin begins his voyage onboard HMS Beagle
1850 Hawaiian Fire Department established
1867 Ontario & Quebec legislatures held 1st meeting
1903 Sweet Adaline a barbershop quartet favorite is 1st sung
1927 Show Boat opens in NYC
1927 Stalin's faction wins All-Union Congress in USSR Trotsky expelled
1932 Radio City Music Hall opens in NY
1934 1st youth hostel opened Northfield Mass
1941 Japan bombs Manila even though it was declared an `open city'
1945 International Monetary Fund established-World Bank founded
1947 1st `Howdy Doody' show (Puppet Playhouse) telecast on NBC
1968 Apollo 8 returns to Earth
1972 LA Kings start Islanders on 12 game losing streak
1972 Lester Pearson Canadian PM (Nobel-1956)
1979 Soviet troops invade Afghanistan
1983 Propane gas fire devastated 16 square blocks of Buffalo
1985 Terrorists kill 20 & wound 110 attacking El Al at Rome & Vienna airports. President Reagan blamed Libyaner Moammar Gadhafi

MySQL Query

SELECT * FROM today_in_history WHERE DAY(mcm_date)=DAY(NOW()) AND MONTH(mcm_date)=MONTH(NOW()) LIMIT 0, 60

PHP

$conn = new mysqli ("server", "user", "password", "database");
mysqli_set_charset ($conn, "utf8");

if ($conn -> connect_error) {
die ("Error: " . $conn->connect_error);
} 

$sql = "SELECT * FROM today_in_history WHERE DAY(mcm_date)=DAY(NOW()) AND MONTH(mcm_date)=MONTH(NOW()) LIMIT 0, 60";
$result = $conn -> query($sql);

echo "<table id='demoTable' class='table table-striped'>";
echo "<thead>";
echo "<tr>";
echo "<th>Year</th>";
echo "<th>Event</th>";
echo "</tr>";
echo "</thead>";
echo "<tbody>"; 

while ($row = $result -> fetch_assoc()) { 

$var_year = date_create($row["mcm_date"]);

echo "<tr>";
echo '<td>' . date_format($var_year, 'Y') . '</td>' . "\n";
echo "<td>" . $row["mcm_event"] . "</td>";
echo "</tr>";
}

echo "</tbody>";
echo "</table>";
$conn -> close();
?>