RE: [PHP-DB] Help needed creating a social network

2006-03-07 Thread Daevid Vincent
- 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

RE: [PHP-DB] Help needed creating a social network

2006-03-07 Thread Miles Thompson
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

Re: [PHP-DB] Help needed creating a social network

2006-03-06 Thread Micah Stevens
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