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! Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.