Songs
';
echo '
';
echo '| SONG | ';
echo 'ARTIST | ';
echo 'LENGTH | ';
echo '
';
while ( $row = mysqli_fetch_assoc($r)){
$color = "#000000";
if($YEAR_UPDATED == 2012)
$color = "#FF9900";
if($YEAR_UPDATED == 2011)
$color = "#660099";
if($YEAR_UPDATED == 2010)
$color = "#FF0000";
if($YEAR_UPDATED == 2009)
$color = "#339900";
if($YEAR_UPDATED == 2008)
$color = "#0000FF";
extract($row);
echo '
';
echo "| $SONG | ";
echo "$ARTIST | ";
echo "$LENGTH | ";
echo '
';
}
echo '';
mysqli_free_result($r); //Free up the resource
} else {
echo '
Unable to connect. We applogize for any inconvenience.
';
echo '
' . mysqli_error($dbc) . '
Query: ' . $q . '
';
}
mysqli_close($dbc); //Close the database connection
//include('footer.php');
?>
