Print Page | Close Window

having truoble while making last post mod

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15100
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: having truoble while making last post mod
Posted By: 1111
Subject: having truoble while making last post mod
Date Posted: 15 May 2005 at 4:07pm
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


Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net