SitePoint Sponsor

User Tag List

Results 1 to 1 of 1

Threaded View

  1. #1
    My precious!!! astericks's Avatar
    Join Date
    Mar 2002
    Location
    Vancouver, BC
    Posts
    1,971
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need advice on existant DB structure

    Hi guys, I just need some advice on my DB structure. The DB is used to store form submissions. The form has around 52 fields and I intend on adding a few more fields for other purposes (let's call it tracking info)...so in all, it's gonna be around 60 fields in all.

    The 52 form fields are gonna be displayed [via php etc, another story] on similar pages.

    1. Now, my question is, do I cram all of them in one table or put the 52 fields in one table and the tracking info in another table? I cant really decide on that

    For now, I've crammed em in one table since I can just loop through an array to display the results.

    2. Also, I've got most of the dropdowns (except numericals) in my DB as ENUMs...any word on that?

    thanks in advance guys.
    asT.
    Last edited by astericks; May 11, 2003 at 16:09.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •