salientking
05-02-2007, 09:48 PM
So im new to the whole dynamic website arena, and DBs for that matter. Im using MySQL 4.1
Im putting together a site, and i want to let users set others users as their "favorites" and display this list of other users on their profile page.
The question is, whats the best way to store this link between users?
I was thinking about having a table that held all links between all users, but that seems pretty inefficient, especially when you have to check to make sure a new link doesnt already exist.
Another idea was to save the id numbers in a large string that resides in the "users" table, and parsing through it. However updating and managing that also sounds like a pain.
Im putting together a site, and i want to let users set others users as their "favorites" and display this list of other users on their profile page.
The question is, whats the best way to store this link between users?
I was thinking about having a table that held all links between all users, but that seems pretty inefficient, especially when you have to check to make sure a new link doesnt already exist.
Another idea was to save the id numbers in a large string that resides in the "users" table, and parsing through it. However updating and managing that also sounds like a pain.