Unable to connect to the database server");
exit();
}
// Select the database
if (! @mysql_select_db($database) )
{
echo( "
Unable to locate Lyrics database
");
exit();
}
?>
0" );
if (!$result)
{
echo("
Error performing query: " . mysql_error() . "
");
exit();
}
// display album/songs in table on left
$album = "";
while ($row = mysql_fetch_array($result) )
{
// add album title
if (!$row["album_title"] == $album)
{
$album = $row["album_title"];
echo("");
}
// create link back to this page with album & song #
if ($row["active"] == 'Y')
{
echo "
";
echo $row["song_name"] . "";
echo("
");
}
else
{
echo("
" . $row["song_name"] . "");
echo("
");
}
}
?>
