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 Quote Link to comment 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. 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.