I am using the following query which should return the latest (top) 12
Topics in my forum. Curently it shows some prepeated Topic_ID values.
(I am using this to add my most recent posts to a XML RSS news feed)
Any help would be very welcome and almost certianly be greeted by loads of free beer!!!
Nathan
PS I am still using
Web Wiz Forums version 6.34 - but I love it!
"SELECT TOP 12 dbo.tblThread.Message,
dbo.tblThread.Message_date, dbo.tblThread.Topic_ID,
dbo.tblThread.Author_ID, dbo.tblAuthor.Username,
&n bsp;
dbo.tblTopic.Subject, dbo.tblTopic.Forum_ID
FROM dbo.tblThread INNER JOIN
&n bsp;
dbo.tblAuthor ON dbo.tblThread.Author_ID = dbo.tblAuthor.Author_ID
INNER JOIN
&n bsp;
dbo.tblTopic ON dbo.tblThread.Topic_ID = dbo.tblTopic.Topic_ID
ORDER BY dbo.tblThread.Message_date DESC"