MySQL

Select rows for the current day and month

YearEvent
1487 Bell chimes invented
1649 King Charles I of Great Britain executed by Parliament
1774 Capt Cook reaches 71ΓΈ 10' S 1820 km from S pole (record)
1847 Yerba Buena renamed SF
1854 1st election in Washington Territory; 1 682 votes cast
1862 US Navy's 1st ironclad warship "Monitor" launched
1889 John Herschel uses camera obscura to photograph 48-inch telescope
1894 US flag fired on in Rio; prompt satisfaction exacted by Adm Benham
1917 1st jazz record in US cut
1922 World Law Day
1933 Adolf Hitler named German Chancellor
1948 Mahatma Gandhi assassinated in New Delhi
1958 1st 2-way moving sidewalk in service Dallas Texas
1969 US/Canada ISIS 1 launched to study ionosphere

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();
?>