best mysql field setup to have a "couples" member profile data saving.
- by acctman
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.
Within the site_member table create multiple field for each field... ex: m_firstname1, m_firstname2, m_age1, m_age2, etc...
Store the couple member data in one field each... and separate with a comma in the data field ex: m_firstname (Mike, Sherry)
Create a separate table site_member_c duplicating the same fields that are in site_member table. This is roughly about 10 fields