# Flash widget database

**URL:** <https://forum.kirupa.com/t/flash-widget-database/263780>\
**Category:** programming\
**Created:** [June 19, 2008, 4:43am UTC](https://forum.kirupa.com/t/flash-widget-database/263780 "2008-06-19T04:43:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ruok](https://avatars.discourse-cdn.com/v4/letter/r/d2c977/32.png) [@ruok](https://forum.kirupa.com/u/ruok)\
**Post date:** [June 19, 2008, 4:43am UTC](https://forum.kirupa.com/t/flash-widget-database/263780/1 "2008-06-19T04:43:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ruok](https://avatars.discourse-cdn.com/v4/letter/r/d2c977/32.png) [@ruok](https://forum.kirupa.com/u/ruok)\
**Post date:** [June 21, 2008, 3:59pm UTC](https://forum.kirupa.com/t/flash-widget-database/263780/2 "2008-06-21T15:59:00Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![ruok](https://avatars.discourse-cdn.com/v4/letter/r/d2c977/32.png) [@ruok](https://forum.kirupa.com/u/ruok)\
**Post date:** [June 21, 2008, 10:52pm UTC](https://forum.kirupa.com/t/flash-widget-database/263780/3 "2008-06-21T22:52:44Z")

</div>

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