[adamdillon]

I have one table that has the following:
song id
song
artist
album
genre

I want to make a another table named playlist that can just have a play list name and the song_id of the songs. What is the easiest way to do this. Would I need to additional tables? Thanks.

[Advertisements]

This will be for a website where i use a table to pull all the songs from a playlist and display them seperatly. Some songs will be apart of more than one playlist.

Edited by adamdillon, 29 April 2008 - 12:29 PM.

[adamdillon]

This will be for a website where i use a table to pull all the songs from a playlist and display them seperatly. Some songs will be apart of more than one playlist.

Edited by adamdillon, 29 April 2008 - 12:29 PM.