Home Search for lyrics Browse for lyrics by artist name Help
   

 

 


Get a free iPod or iPod mini! Get a free flatscreen monitor!

Albums for :

Album: '. $album .'
'; $SQL_song = 'SELECT id, song FROM lyrics_database WHERE artist = "'. $artist .'" AND album = "'. $album .'" ORDER BY song'; $result_song = mysql_query($SQL_song); if(!mysql_num_rows($result_song)) { echo '  No songs from that artist and/or album found!'; } else { while($row_song = mysql_fetch_array($result_song)) { $id = $row_song['id']; $song = $row_song['song']; echo '     - '. $song .'
'; } } echo '
'; } $SQL = 'SELECT album FROM lyrics_database WHERE artist = "'. $artist .'" AND album = "Other Songs" LIMIT 1'; $result = mysql_query($SQL); if(mysql_num_rows($result)) { $row = mysql_fetch_array($result); $album = $row['album']; echo '  '. $album .'
'; $SQL_song = 'SELECT id, song FROM lyrics_database WHERE artist = "'. $artist .'" AND album = "'. $album .'" ORDER BY song'; $result_song = mysql_query($SQL_song); if(!mysql_num_rows($result_song)) { echo '  No songs from that artist and/or album found!'; } else { while($row_song = mysql_fetch_array($result_song)) { $id = $row_song['id']; $song = $row_song['song']; echo '    - '. $song .'
'; } } echo '
'; } } ?>