:
You know bob who knows john who knows carrol who knows Sam.
Sam <- carrol <- john <- bob <- you
Etc.
> -Original Message-
> From: Micah Stevens [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 10:28 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB
t;- carrol <- john <- bob <- you
Etc.
> -Original Message-
> From: Micah Stevens [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 10:28 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Help needed creating a social network
>
>
> CREATE TA
CREATE TABLE `users` (userID int(11) not null auto_increment, primary
key(userID), name tinytext not null, email tinytext not null);
CREATE TABLE `links` (userID int(11), key (userID), friendID int(11),
key(friendID));
You have friends!!";
while ($f = mysql_fetch_assoc($friends)) {
echo "{$f['
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 p
