Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    28

    Unanswered: need sql statement in mysql

    Hi,
    I am want on sql statement for my table. I am having one table call friends in that table i will store userid and friendid like this.....


    iUserID iFriendID
    1 3
    1 2
    1 4
    2 4
    3 6
    6 2
    5 7
    7 8

    How can i get parent and child record suppose my id is 3 i have to get userid "3"'s parent records and child record. How can i get this all records....

    1 3
    1 2
    1 4
    2 4
    3 6
    6 2

    Thanks in advance

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    not enough info

    there is no parent or child column, just user and friend
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •