best mysql field setup to have a "couples" member profile data saving.

Posted by acctman on Stack Overflow See other posts from Stack Overflow or by acctman
Published on 2010-04-07T09:19:59Z Indexed on 2010/04/07 9:23 UTC
Read the original article Hit count: 346

Filed under:

Couple database profile entry, which would be the best way to save data. Also the data will be retrieved via php coding and if it could be down with one query code that would be ideal.

  1. Within the site_member table create multiple field for each field... ex: m_firstname1, m_firstname2, m_age1, m_age2, etc...

  2. Store the couple member data in one field each... and separate with a comma in the data field ex: m_firstname (Mike, Sherry)

  3. Create a separate table site_member_c duplicating the same fields that are in site_member table. This is roughly about 10 fields

© Stack Overflow or respective owner

Related posts about mysql