Basically the idea being it will have one page which will list all the tracks, one where you can add and anouther page that lists all the playlists and one that lets you create playlists.
Now the one that create's playlist i was thinking needs a drop down bow that lists all the tracks that are in the database and you select the one you want and click add and keep doing that untill you have all the tracks on the list at which point you would click save and it would be listed in the playlists page.
Now the dropdown list of all the tracks is great but a friend rightly pointed that once that lists of tracks grows a dropdown would be slow and potentially crash the database. Now i was thinking does anyone one else know any effective way in which you can either search or list the track names which are stored in mysql. I was thinking maybe some jquery script but could not think what. I want to ideally use whatever would have the leaset cpu/server load tecnologically.
Using this method, the person starts typing the track, the database is searched, and they are able to click the name of the track, adding it to your list.