Facebook Like Wall Posts - Database help
hi guys,
I'm building a small app which copies facebooks wall. I have a table called Wall_Posts(WallPostID(int PK), WallPost(varchar), PostTime, AccountID(accountid of logged in user))
then when friends reply to a wallpost (WallCommentID, WallComment, PostTime,
WallPostID, AccountID)
this works fine. Say on my wall I create a post called Test 1.
Friends can the click comment and a record will be created in the wall_comment table for that specific wallpost.
This is on my wall.
What I'm battling to understand is, say I open up a friends wall and add a post? How do I display it on my wall for example Nitesh posted ..... on Gary's wall
Re: Facebook Like Wall Posts - Database help
edited:
you can use
Code:
select WallComment, A.UserName from wallpost W inner join Wall_Posts WP on W.WallPostID = WP.WallPostId INNER JOIN Account A ON A.AccountID = WP.AccountID WHERE W.AccountID = @AccountID(accountid of logged in user)