How to store Friends and Friends of friends In my Database

view full story

http://www.daniweb.com – I am developing a database whre people can register and connect with friends. I am stack at how to store friends. Should I create a Table Friends with fields Friend_ID, Reg_ID, Reg_ID_2. Reg_ID and Reg_ID_2 are values from the Registration table which is the primary key. Thank you for your help. (General)