brown2005 Posted November 17, 2009 Share Posted November 17, 2009 I want to track referrals, with 2 levels, 1. people you refer 2. people they refer Would I be best to include a field in the members table say referredby and then this will be the ID of the person who referred you, or would it be better to have a spearate table (referrals) referrals_id referrals_by referrals_of referrals_date like that. thanks Link to comment https://forums.phpfreaks.com/topic/181864-referrals/ Share on other sites More sharing options...
cags Posted November 17, 2009 Share Posted November 17, 2009 Since a person can assumably refer multiple other people using a single table wouldn't really work. You would end up with one field populated by multiple values, which is something to avoid. Personally I'd probably just have a Referrals table. That way you can find all required information by simply searching the referrals_by and the referrals_of columns. Link to comment https://forums.phpfreaks.com/topic/181864-referrals/#findComment-959138 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.