Classic ASP Discussion - Displaying records

Print Page | Close Window

Displaying records

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=13576
Printed Date: 28 March 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Displaying records

Posted By: deltrotter
Subject: Displaying records
Date Posted: 30 January 2005 at 5:05pm

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

Replies:

Posted By: Gullanian
Date Posted: 06 February 2005 at 9:19pm

You'll need to create a query to select from multiple tables, take a look on the SQL lessons on w3schools.com on how to achieve this in the most efficient way possible.