ok Posted September 1, 2008 Share Posted September 1, 2008 Ok here is the scenario. This is tell a friend contest. People can sign in and just tell their friend as many as they about a particular promo. So for example if Joe tell his friend, anna and josephine. He will have this record below. joe --------- anna josephine Then anna also invite his friend joey, jack, george and karen. now anna have this table below, anna --------- joey jack george karen and vice versa. but anna can't invite joe, since joe invited her already. anyway what is the best Relational Database for this? Thank you! Link to comment https://forums.phpfreaks.com/topic/122191-database-relationship/ Share on other sites More sharing options...
burn1337 Posted September 1, 2008 Share Posted September 1, 2008 I would say something like Although not sure it would work just off the top of my head UserId UserName ReferedUserId ReferedUserName each refered person a new row, or UserId UserName ReferCount ReferenceId ReferedName ReferedId Link to comment https://forums.phpfreaks.com/topic/122191-database-relationship/#findComment-630812 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.