jjk2 Posted September 7, 2008 Share Posted September 7, 2008 when you have members that has different memberships.... members table: members_id | name | email membership table: members_id | membership_id | membership title is that how you do it ? so members table do not require membership_id.... also what is the fastest way to call something like member.membership thanks! Link to comment https://forums.phpfreaks.com/topic/123133-joint-tables/ Share on other sites More sharing options...
Mchl Posted September 7, 2008 Share Posted September 7, 2008 It depends on what 'membershibs' are in your case. Link to comment https://forums.phpfreaks.com/topic/123133-joint-tables/#findComment-635886 Share on other sites More sharing options...
snk Posted September 8, 2008 Share Posted September 8, 2008 if you want to have a member with multiple memberships then your tables are correct. if you want to see the membership of a member then you have to join your tables. Link to comment https://forums.phpfreaks.com/topic/123133-joint-tables/#findComment-636395 Share on other sites More sharing options...
revraz Posted September 8, 2008 Share Posted September 8, 2008 Move your membership_id to the left so you dont think your member_id is your membership_id. Link to comment https://forums.phpfreaks.com/topic/123133-joint-tables/#findComment-636549 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.