Easiest method for 'Show new replies to your post'

[blackcell]

I am wondering, what is the easiest way to code something like phpfreaks' "Show new replies to your posts." feature? I have been tossing ideas around but can't seem to figure it out.

[prcollin]

I am wondering, what is the easiest way to code something like phpfreaks' "Show new replies to your posts." feature? I have been tossing ideas around but can't seem to figure it out.

 

Create a table for posts

 

the create a table that is for replies

 

have the unique id for hte post(name) be the identifier for the replies

 

have it so that each new reply is submitted to the replies table with the uique id and if the id is already present dont add again but if it isnt then create new row with id

 

then just have hte rows in the replies table counted.  and if the number is changed send a link to the original post to each row (name) in the replies table.  That way every time a new reply is submitted the number changes and the link is sent

 

or is there an easier way?  this is how i did it on my forum

[keeB]

I think of a topic on a message board as a container.

 

http://en.wikipedia.org/wiki/Container_%28data_structure%29

 

If I was implementing my message board with that idea in mind, I might load all (or some, or specific) posts which contain the user, and find the last post.