jodbowrs Posted November 16, 2011 Share Posted November 16, 2011 Server version: 5.1.53-community-log Maybe the question I should be asking then is how should I set up one or more table(s) to contain our members contact info plus the multiple fields of work that they work in? Link to comment https://forums.phpfreaks.com/topic/251269-better-mysql-table-structure/ Share on other sites More sharing options...
requinix Posted November 16, 2011 Share Posted November 16, 2011 Simply, a table for the members including contact information, a table for fields of work, and an associative table between the two. If you don't know what types of contact information you'll be recording then there's two more tables: one for type of information ("Phone", "Email", etc.) and another associating contact with type of information ("Phone") with the actual information ("555-1212"). Link to comment https://forums.phpfreaks.com/topic/251269-better-mysql-table-structure/#findComment-1288764 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.