Tables and rows in wwforum.mdb

I changed default.asp on my site to do what you're after and a bit more. www.crsc.co.uk/forum/default.asp

First thing I did was to change the select statement to make sure that the subject was returned from the database:

strSQL = "select tblThread.Thread_ID, tblThread.message_date, tblThread.topic_id, tblTopic.subject, tblAuthor.Author_ID, tblAuthor.Username"
strSQL = strSQL & " from tblThread, tblTopic, tblAuthor"
strSQL = strSQL & " where tblTopic.Forum_ID = " & intForumID
strSQL = strSQL & " AND tblThread.Topic_ID = tblTopic.Topic_ID" strSQL = strSQL & " AND tblThread.Author_ID = tblAuthor.Author_ID" strSQL = strSQL & " order by message_date desc"

Then I set up a new variable to store the subject title in:

strLastEntrySubject = rsCommon("Subject")

All that was left then was to display the subject title.

I was going to copy in the relevant code at this point but the formatting went all screwy since I was pasting in HTML tags. Drop me a PM with your email address and I will send my default.asp over.

Hope this helps.