Hi
I am trying to develop a discussion area for a cancer nursing project I am working on. I can do most of it, but one page has kind of got me puzzled as to the best way of doing it.
Its the page where I will list all of the Topics in a Forum (showing the topic title, the topic starter, number of replies, date of last reply and the poster).
The tables I have are:
tblTopics
TopicID
ForumID
TopicTitle
NumberReplies
tblPosts
PostID
TopicID
MemberID
PostDate
tblMembers
MemberID
FirstName
LastName
I would like to display this:
Topic Title - Topic Starter - NumberReplies - LastPostDate - LastPoster
Can anyone point me in the right direction? I'm looking for the most efficient method - bearing in mind that in the future there may be 100's of topics with thousands of posts in tblPosts. I'll set up paging for every 20 topics or so.
Many thanks for any help.
Cheers
Del
Topic Options
Post Options
Thanks(0)
