How to create the "twitter follower" feature ? How should DB look like ?

**aaron888** · Jul 12, 2009 22:51

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

Thank you.

**Gears** · Jul 13, 2009 00:03

Perhaps you could implement an RSS feed

**aaron888** · Jul 13, 2009 04:13

Originally Posted by Gears

Perhaps you could implement an RSS feed

sounds like a good solution, and a good way out.
did you mean, an RSS feed for each joke member ?

then u mean... all the normal users... subscribe to that member ?