Multiple Check Boxes - What to do?

Discussion in 'PHP' started by adamjblakey, Dec 14, 2007.

  1. #1
    Hi,

    I have a form that has around 20 check boxes for qualities that you seek in your partner. So the user can select up to 20 qualities each. I am wondering what is the best way to do enter these into the database?

    Would i be best entering these into the database comma separated into one field or create different fields for each quality. I just say this as i need to match up these later with different users for a love match. Will i have any problems matching them up if they are comma separated as some users might enter 3 qualities and some might enter 15.

    Cheers,
    Adam
     
    adamjblakey, Dec 14, 2007 IP
  2. Gawk

    Gawk Peon

    Messages:
    427
    Likes Received:
    36
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Separate fields, this will also make other functions easier such as sorting by individual qualities.
     
    Gawk, Dec 14, 2007 IP