Thread: forms and mysql

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    4
    Rep Power
    0
    What I am after here is some intelligent advice concerning the best way to store some data the user enters when siging up for access to my site.
    When the user signs up, he will answer various questions about himself. Some of the questions will be answered using the html form element select, which will provide them with a list of choices from a drop down list as i am sure you are familiar with. My question is, how should i store this data so i can easily modify it later? (add questions, change answers in case of spelling errors etc.) Should I make a table for each question? Should I just store the full text of the answer? Should I create a mapping from answer to integer and store that?
    Any advice appreciated. Thanks.

  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Welcome to the wonderful world of database normalization! Anytime you have a limited set of responses to a form element, it's a good idea to use normalization. You create a table of those responses mapped to an integer id. You can then store in your "main" table just the integer. Queries are faster as it's quicker to compare an integer and the tables can be joined. If you are worried that you might have several queries to build the form, you can create a static page that is updated only when you make a change to the table.

Similar Threads

  1. About forms, php, and mysql
    By ekyl in forum PHP Development
    Replies: 2
    Last Post: November 5th, 2003, 11:51 AM
  2. newbie question Forms to MySQL
    By dvx_movies in forum PHP Development
    Replies: 3
    Last Post: November 5th, 2003, 10:42 AM
  3. inserting into MySQL with Forms
    By jill_safc in forum PHP Development
    Replies: 17
    Last Post: September 8th, 2003, 05:08 AM
  4. Dates messed up in forms with mysql
    By zbriu in forum MySQL Help
    Replies: 1
    Last Post: August 5th, 2003, 07:23 AM
  5. Replies: 2
    Last Post: February 17th, 2002, 05:59 PM

IMN logo majestic logo threadwatch logo seochat tools logo