acctman Posted April 7, 2010 Share Posted April 7, 2010 Can someone explain the below statement to me with an example/sample... basically what i'm trying to do is handle a member couple profile which will have multiple Firstnames, Age, Height, etc about 10 fields will be similar. You could create duplicate fields, but simply add a single extra field, "coupleId", which would have a unique id for each couple; and two rows (one for each person) per couple; then JOIN the table against itself with a constraint like a.coupleId = b.coupleId AND a.id <> b.id so that you can condense the data into a single result row for a given couple. Link to comment https://forums.phpfreaks.com/topic/197883-example-needed-for-mysql-field-setup/ Share on other sites More sharing options...
fenway Posted April 9, 2010 Share Posted April 9, 2010 Huh? Link to comment https://forums.phpfreaks.com/topic/197883-example-needed-for-mysql-field-setup/#findComment-1039589 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.