Hello everyone!

so in a social networking site, what would be the best way to manage a contact list? i thought throwing everyone into a table and having an "Is friend of" column... but then i thought maybe that would be a bad idea, maybe programmatically adding a table per registered user to represent a friend-list. im just not quite sure. any direction would be greatly appreciated. I really dont know how i would begin to manage this efficiently.

thanks everyone :)

hello.

Sure, the solution is not to add a table per user (1000 users means a 1000 tables!!!)

An intermediate table with userid,userid doesn't sounds bad for me. (in fact, IMHO, I don't think there is other way to do it).

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========