How about something like this
Users table
user_id
user_name
user_password
user_whatever
and then
Relation table
rel_id
user_id
friend_id
and then selecting from relations table
On Fri, 2006-04-07 at 14:47 -0700, Martin Gallagher wrote:
> urrently I link them using 2 separate fields for the members: id1,
> id2. So,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
