How to create facebook like friend system

Question

database and php MySQL coding

Answer 1

Store friends ids in comma separated string. Then query each id for user information.

To remove or add friend, change the comma separated string to array and then you can add or remove ids from there.

Change the array back to string and update friends column.