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

Hi

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.



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