palylist for every user

[realcoder]

i just make a very little script my first one 😛
http://www.hostrox.com/proj
here is stil not desinged complety
but i want to add one more future in this that every user can make his own playlist after registering... i have make a table of users where is one COLUM is playlist.. i can send name of song in that colum & for separating that song name i'll use : or any other symbol
but problem is that how i'll fetch that all songs one by one in my playlist
please suggest me some good code for making a good playlist 🙁
i'll be very tahnkfull to all of you 😕
and also help how can i make this more good and also in SEO😕

[big_nerd]

realcoder,

Make 2 tables:

playlist, and playlist_songs

Have the playlist table hold the user, playlist name, etc.

Have the playlist_songs table hold all of the songs, with one column for 'playlist_id'.

You can then use a simple join statement..

This would then allow a (virtually) unlimited number of songs / playlists per user.

[realcoder]

thanks buddy not bad ...i like your idea thanks 🙂