MySQL Forums
Forum List  »  Newbie

Best way to set up a member database
Posted by: Milo Vicente
Date: February 27, 2016 09:09AM

Dear All,

I´m setting up a database with what may turn out to be a large number of members. So I have a a table in the db called users, containing usernames, passwords etc. I´ve made another table with messages, where the messages between users are stored.
Now my problem is what I do with users and their friends lists. I could make a table more for that purpose only, where each row again is a username, and then each column contains a friend of the user. Or I could have just one row in the first table, where friends are separated by for instance a "/", and will be parsed by a PHP script. More complicated for me, but maybe alot more effecient.
Or, is there a different approach you could recommend?

Thanks in advance!

Options: ReplyQuote


Subject
Written By
Posted
Best way to set up a member database
February 27, 2016 09:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.