Skip navigation
novembr1111
novembr1111 Calculating status...
Currently Being Moderated

Filter Recordset from another recordset's results???

Apr 23, 2012 10:27 AM

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.

522 Views   3 Replies   Latest reply: the_shocker, Apr 24, 2012 2:26 PM
 
Replies
  • the_shocker
    Currently Being Moderated
    1. the_shocker,
    Apr 23, 2012 1:13 PM   in reply to novembr1111
    Report

    Use a JOIN in your query. Look it up.

     

    best,

    Shocker

     
    |
    Mark as:
  • novembr1111
    Currently Being Moderated
    2. novembr1111,
    Apr 23, 2012 3:12 PM   in reply to the_shocker
    Report

    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

    FROM users

    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

     
    |
    Mark as:
  • the_shocker
    Currently Being Moderated
    3. the_shocker,
    Apr 24, 2012 2:26 PM   in reply to novembr1111
    Report

    Is there a way to filter the results by a session variable?

     

    Use a WHERE in your query. Look it up.

     

    best,

    Shocker

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points