Posted - 02/27/2013 : 03:50:23
| Hi! I am about to design a page, that request to display all users actions in time order, most likely action is posts, but there are some more, like someone joined a group, someone changed some info.
so, it should display on the page like the following:
1 a post 1min ago
2 a post 2min ago
3 someone joined some group 3min ago
4 a post 4min ago
5 a post 5min ago
6 someone changed some info 10min ago
7 a post 11min ago
my question is, how can I do so?
because I can not put all these data in a single table, they are different types of data, but if I save them in different tables, then how can I select them, because I should put them together by time order. If I select them seperately, then how do I know which table I should take how many number of datum? for example, in 2 hours, there are only posts, and there are 2000 posts, if I just need 100 posts, then I should not select any other actions, but if some one just changed some info...
this is a very difficult problem for me, could some one give me some idea about this?
thanks in advance!