Today in Music History

What happened today in music history:

‘. $fullmonth[$month].’ ‘.$day .’

‘;

$username = DB_USER;
$password = DB_PASSWORD;
$hostname = DB_HOST;
$dbname = DB_NAME;

$mysqli = new mysqli($hostname, $username, $password, $dbname);

if ( $mysqli->connect_errno )
{
echo ‘Sorry, unable to get content.’;
}
else
{
$sql = “SELECT year, data FROM todayinmusic WHERE month = “. intval($month) .” AND day = “. intval($day);
$results = $mysqli->query($sql);

while ($row = $results->fetch_assoc())
{
echo ‘‘.$row[‘year’].’: ‘.$row[‘data’].’

‘;
}

$results->free();
$mysqli->close();

$previousday= $day – 1;
$nextday = $day + 1;
$previousmonth = $month;
$nextmonth = $month;

if ($previousday == 0)
{
$previousmonth=$month-1;
$previousday=$daysmonth[$month];
}

if ($nextday > $daysmonth[$month] )
{
$nextmonth=$month+1;
$nextday=1;
}

if ($previousmonth==0)
{
$previousmonth=12;
$previousday=31;
}

if ($nextmonth==13)
{
$nextmonth=1;
$nextday=1;
}

echo ‘

<<< Previous day

Archives

Next day >>>

‘;
}

?>