database modeling for a friend list

[eluser]Krzemo[/eluser]
I guess your model is the only proper one.
Why do you have to search both id fields if you are looking only for friends?

For friends of only one user below should work:

Code:

SELECT u.name
FROM users u, friends f
WHERE u.id = f.friend_id
AND f.user_id = <your_user_id>
AND f.status = 1

For friends all users try smth like that:

Code:

SELECT u1.name AS user_name
, u2.name AS friend_name
FROM users u1, friends f, users u2
WHERE u1.id = f.user_id
AND u2.id = f.friend_id
AND f.status = 1

Im old fashioned SQL quy, but translating it to AC shouldnt be a problem.

Regs