- 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 TABLE `users` (userID int(11) not null auto_increment, primary
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] Help needed creating a social network
CREATE TABLE
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));
?php
$friends = mysql_query(select users.name, users.userID from users