Facebook Like Wall Posts - Database help

[Nitesh]

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

[riteshjain1982]

edited:


you can use

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)