XML Playlist for MP3 Player

[validkeys]

I just figured out how to dynamically create an xml playist file from my db of songs. What I am wondering though is that my site has many different artists and on each of their pages is an audio player whose playlist I want to have dynamically generated. Obviously having one xml file wont do. What is the best way for me to go about this? Have an xml file for each user in their user folder ex. user5playlist.xml and then just write the dynamically generated xml playlist to that user's xml file?

 

I hope that made sense. I have been staring at the screen for a long time

\

thanks in advance

[magic2goodil]

I would say create a database table to hold user playlists and give each playlist and PID(playlist ID) and also have a UID reference to each one.  That way you can OOP a little better if you decide to create your own playlist class to run functions on user's playlists.  As far as creating files for them, you could actually just create the fields in the database table to hold each user's playlist and use something to separate the songs so you can successfully call them later and display as a correct playlist.  This will also save on file space and allow you to have 1 simple php page that will be able to call any plylist and write it dynamically from the database for that user temporarily.