Hello everyone,
I'm in the process of creating a community website and i was wondering what the best way to go about a problem of mine would be. I'm sure most of you have seen what I'll be talking about, even this site has it, I want to add a function to my site so people can add other users as buddy's or enemie's (block them from their profile). I've been contemplating how to do this and one of ym ideas was creating a table in my DB that has all the users listed vertically and horizontally, kind of like a times table in math, and have numbers corresponding to whether they are a buddy or enemy. If anyone else has any better ideas please let me know, as i have never tried this before. I'm sure there is an easier way, but it is not showing itself to me.
-Thanks in advance, Mindless_Spider-

Table:

friendship_id (Primary), User_id , other_user , type

Where type can be 1 -> friend , 2 -> enemy..

that would do it..

Peace,