Help needed creating a social network
| From: | Daevid Vincent | Date: | Tue, 07 Mar 2006 05:47:24 +0000 |
| Subject: | Help needed creating a social network | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41398@lists.php.net to get a copy of this message | ||
Anyone have some pointers at a HowTo on creating a social network?
Basically I need to show people in your immediate network, and also friends
of your friends, etc... Like the whole 'six degrees of separation' thing.
Ala: myspace, friendster, etc. ad nauseum.
I prefer mySQL and PHP, but I could port from most any code. I guess I'm
mostly interested in the theory of this an how do I set up the tables
properly and what is the magic incantation (JOIN) to get this "chain" of
people.