$artist->artist_name Song Lyrics


"; if (isset($page[1])) { $result = mysql_query("SELECT * FROM song_database WHERE song_artist_id='3' AND song_id='$page[1]'") or die("Please Contact Admin: " . mysql_error()); $row = mysql_fetch_object($result); $lyrics = nl2br($row->song_lyrics); echo"
"; $result = mysql_query("SELECT * FROM album_database WHERE album_artist_id='3' ORDER BY album_release_timestamp DESC") or die("Please Contact Admin: " . mysql_error()); while( $album = mysql_fetch_object($result) ) { echo " "; } echo"
$album->album_name, Krystal Meyers

$album->album_name Buy Now!

 "; $songlist = mysql_query("SELECT * FROM song_database WHERE song_album_id='$album->album_id' ORDER BY song_track_number") or die("Please Contact Admin: " . mysql_error()); while( $songs = mysql_fetch_object($songlist) ) { echo"

"; if ($songs->song_lyrics !="") { echo"$songs->song_track_number. $songs->song_name
"; } else { echo"$songs->song_track_number. $songs->song_name"; } echo"

"; } echo"

$row->song_name

$lyrics

"; } else { echo" "; $result = mysql_query("SELECT * FROM album_database WHERE album_artist_id='3' ORDER BY album_release_timestamp DESC") or die("Please Contact Admin: " . mysql_error()); while( $album = mysql_fetch_object($result) ) { echo " "; } echo"
$album->album_name, Krystal Meyers

$album->album_name Buy Now!

 "; $songlist = mysql_query("SELECT * FROM song_database WHERE song_album_id='$album->album_id' ORDER BY song_track_number") or die("Please Contact Admin: " . mysql_error()); while( $songs = mysql_fetch_object($songlist) ) { echo"

"; if ($songs->song_lyrics !="") { echo"$songs->song_track_number. $songs->song_name
"; } else { echo"$songs->song_track_number. $songs->song_name"; } echo"

"; } echo"
"; } echo" "; include 'globals/footer.php'; ?>