MySQL

Select rows for the current day and month

YearEvent
1822 Boston - Mass incorporated
1859 Faust by Charles Gounod premiers in Paris
1895 LA Railway established
1917 US Supreme Court upheld 8 hour work day for RR
1918 Congress authorizes time zones & approves daylight time
1920 US Senate rejects Treaty of Versailles for 2nd time
1928 Amos & Andy debuts on radio
1931 Nevada legalized gambling
1942 FDR orders men between 45 & 64 register for non military duty
1945 800 killed as Kamikaze attacked USS Franklin off Japan
1949 1st museum devoted exclusively to atomic energy - Oak Ridge - Tn
1951 Herman Wouk's Caine Mutiny published
1953 Academy Awards ceremony (1st telecast)
1954 1st rocket-driven sled on rails tested - Alamogordo - NM
1974 Anne Klien dies at 50
1976 Buckingham Palace announces separation of Princess Margaret
1979 House of Reps begin day-to-day TV broadcasts
1981 Two workers killed in space shuttle Columbia accident
1984 Kate & Allie premiers
1987 PTL leader Jim Bakker resigns
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();
?>