I'm tryin' to do a mod that will find the last 10 latest posts/replys and I'm stuck
I did like this
strSQL = "SELECT TOP 10 " & strDbTable & "Topic.Topic_ID, " & strDbTable & "Topic.Subject, " & strDbTable & "Forum.Password, " & strDbTable & "Forum.Forum_name, " & strDbTable & "Forum.Forum_ID, tblThread.Author_ID, tblAuthor.Username, tblThread.Message FROM "
strSQL = strSQL & "((tblTopic INNER JOIN tblThread ON tblTopic.Last_entry_date = tblThread.Message_date) INNER JOIN " & strDbTable & "Forum ON " & strDbTable & "Topic.Forum_ID = " & strDbTable & "Forum.Forum_ID) "
strSQL = strSQL & "INNER JOIN " & strDbTable & "Author ON " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID "
strSQL = strSQL & "WHERE IsNull(" & strDbTable & "Forum.Password) = True and " & strDbTable & "Forum.Forum_ID<>10 " 'admins forum.
strSQL = strSQL & "ORDER BY " & strDbTable & "Topic.Last_entry_date DESC;"
|
when I'm doing tblTopic.Start_date = tblThread.Message_date
it working perfect
but I want to retrieve thr replyer name and not thread author name.
hope you understand and can help me ;]
10xz
Topic Options
Post Options
Thanks(0)
