need in sql statement in mysql?

[benaya p]

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
when i query like this it will display..
select * from tbl_friend where (iUserID=3 or iFriendID=3)
iUserID iFriendID
1 3
3 6



Not like this i want when i query i want like this....

iUserID iFriendID
1 3
1 2
1 4
2 4
3 6
6 2
i want like this..
iUserID iFriendID
1 3
1 2
1 4
2 4
3 6
6 2