How to create the "twitter follower" feature ? How should DB look like ?
Hello Wonderful Sitepoint Members,
Recently I have been using twitter, and I really like their feature of "Followers". It is where people can subscribe to that user and follow that users updates.
I would also like to implement this for my joke website.
My jokes website has got many jokes uploaded by many members.
Each member has their own primary key unique "ID".
My member table is called "user".
I also have a "jokes" table, where it stores the title of joke bla bla bla....
each joke have a primary key called "jokeID"
So, the question is,
How do I create a feature like twitter, where people can subscribe to that joke member,
and how should I set up the database based on that ? should every joke member have its own table and etc..
Thanks so much for your guidance and advice.
I appreciate your time taken to post a reply.
Sample of coding would be good