Flash widget database

programming
1

What tables and fields in a database would you suggest I create for a flash widget that stores the user’s personal music playlists in XML files? :puzzled:

Thanks,
PHP Noob

2

Thanks for the response.

ahmednuaman, Can you explain why you chose those tables and fields?

Essentially:
I have a flash music player I developed.
It uses an XML file for song info.
I’ve created a simple php login system
I found code to add form contents to an XML file directly
Now I need to associate that XML file with the logged in user

Thanks for you helpful insight

I’m so close to my goal!

3

I’ve set up those tables now.

So would the user id in the playlist table, the user id in the user_playlist table, and the track id in the track table all be the auto-increment column?

Thanks,
PHP Noob