Pixulated
Reputation: 33
What is the best way to go about connecting users within a database into a relationship which can be identified?
I need to connect users, so that for example a user can connect/follow another user through a button/link on their profile page. This would then allow them to view their (user now connected with) future news items which they post on the site and which are stored within the database.
How would I go about doing this within a table for say, MySQL?
I already have a user table created, and also have a news_item table.
Upvotes: 1
Views: 82
Answers (1)
Related Questions
- Database design issue regarding identifying relationships and many to many relationships
- Linking Users table to other entities/tables
- Structure of database for representing connections between users
- best way to store 1:1 user relationships in relational database
- Associate data to users
- Best way to define a MySQL relationship
- MySQL: Adding connections between people
- Associate user with multiple other users
- How to arrange MySQL database to track users that have associated to multiple primary keys?
- One-to-many relationship?