P
Patrick.O.Ige
There is a message board application.
And the DataGird is being used to populate the threads.
Topic,Startedby replies,views and Date Posted.
But now i want to add LAST POST if there is any.
There are 2 tables post and reply
On the Last Post column i would like to retrieve the Last Reply from the
reply table
into that column so for exmaple "1/1/2005 @13:49pm by Name"
the reply table has the columns replyid,name,subject,dt(date),message and
postid.
What would be the best way to do this?
And the DataGird is being used to populate the threads.
Topic,Startedby replies,views and Date Posted.
But now i want to add LAST POST if there is any.
There are 2 tables post and reply
On the Last Post column i would like to retrieve the Last Reply from the
reply table
into that column so for exmaple "1/1/2005 @13:49pm by Name"
the reply table has the columns replyid,name,subject,dt(date),message and
postid.
What would be the best way to do this?