i want to design a table in which i want to store the names of friends... for instance
there are three users
user 1 having 5 friends
user 2 have 8 friends
user 3 have 2 friends
i just want to save the name of the user and the names of all friends in 1 or in more tables, so that i can retrieve all the friend's name by giving 1 query.... plz give me the suggestion how may i design table
n there is no limit to make friends, so the counting may by cross 100 also....