Six Degrees of Separation (well maybe not 6...)

[stublito]

I need to do a social networking table/layout for our membership database. The concept is who know who?

I've done a cheezy one based on a join table and a portal from Name 1 to Name 2 that gets me the all the friends of one friend, but there are duplicates in the results and it isn't very elegant.

I think I'm going to need a recursive script that "follows the branches of the tree".

Has anyone done this?

Thanks

Peter

[mr_vodka]

See if this helps you.

Recursive Data Structures