I have a database full of user info including a unique userID.... I have another table where user relationships are defined to make connections liek "friends". This table uses only the userID's and none of the user information... I want to display a users relationships/connections by photo and name one their page but only have a recordset that returns the userID's of their connections... Is there a way to run another recordset like "connectioninfo" that is filtered by all a users conection's userID's? hopefully that all made sense... any help is really appreciated. Thanks a lot.
Thank you for the help. I played with that and have figured out how to make the relation. Is there a way to filter the results by a session variable? I want for the user to only see his relationships... this is what I have now...
SELECT users.first_name, users.last_name, users.location, relationships.status
INNER JOIN relationships
ON users.id = relationships.userA
This will return a combination of the two tables like I spoke of but I need to filter the results so that - WHERE relationships.userA OR relationships.userB = $_SESSION['id'] I have this same where clause but I can't seem to make it work... any heal would be great.
Thanks a lot