everyone, can someone please help me out on this: I am working on a social networking site as a class project, but I can't seem to find a way to setup friends and/or follower/following database. Please help. Thanks everyone. I am working with PHP/MYSQL.
You can create something like this of course you can add/rename columns.
user_table
friends_table (Combination user_id_1/user_id_2 unique key)
follower_table (Combination user_id_1/user_id_2 unique key)