My first instinct was to have each song be a record in the database that is tied to an album (maybe by that album's ID) I have about 5k albums in my database so I have my work cut our for me if I do that.
Any ideas/suggestions so that the user may search for songs?
Here's an example of an insert statement with data of a particular album that is currently in my database so you can get an idea of what I currently have:
Expand|Select|Wrap|Line Numbers
- INSERT INTO `products_description` (`products_id`, `language_id`, `products_name`, `products_description`, `products_url`, `products_viewed`) VALUES
- (1, 1, 'BOBBY VALENTIN - THE BEST - CD', '1- HURACAN \r\n2- VETE PA LLA \r\n3- PIRATA DE LA MAR \r\n4- BESO BORRACHO \r\n5- GUARAMBEMBERE \r\n6- POBRE SOY \r\n7-SOY BORICUA \r\n8- SON SON CHARARI \r\n9- PIENSALO BIEN \r\n10- PAPEL DE PAYASO \r\n11- TOTAL PARA NADA', '', 21);