This topic is locked

Member Table With Parent And Child Members

1/1/2013 10:16:50 PM
PHPRunner General questions
D
davme author

I have a membership database I am converting into a phpRunner project. Each paid member is able to have a handful of free associated memberships. The associated memberships are still members in the main table.
I want to show a list of associated members when viewing a paid member account.
I've tried two methods of associating the data but cannot figure out how to get either to work in phpRunner.
Method 1:

I've added a "parent_member" column to the members table and populated it with the id of the paid member in each associated membership row.
Method 2:

I've created an member_association table. The first column is the parent_member id and the second column is the associate_member id with both linking back to the same id column in the main member table.
I would appreciate any suggestions on how to get a parent/child relationship view using the data from the same table.
Thanks!!!

Sergey Kornilov admin 1/2/2013

DavMe,
it's not easy to decipher what you are after.
Could you post a couple of screenshots that explain what is the current database structure and an example of what you trying to build? Probably that can help people understand what you looking for.