Web Wiz Forums - Script for the front *.asp page

Print Page | Close Window

Script for the front *.asp page

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=8953
Printed Date: 07 April 2026 at 1:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Script for the front *.asp page

Posted By: lodogg
Subject: Script for the front *.asp page
Date Posted: 15 January 2004 at 9:17pm

I know I asked this before:( But I searched and searched and I would like a script that will call up the top 5 or 10 most recent posts to my main *.asp web page. I still can't find it. Can some one please post a link or just post the scipt. I have the mod to post the 5 most recent posts to the main FORUM page but I would like to pull these most recent post on my front WEB page...

Thanks in Advance

You can see what I'm trying to accomplish from my link below.

Thanks.................

You can see what I'm trying

-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun

Replies:

Posted By: Gullanian
Date Posted: 15 January 2004 at 9:21pm

Simple:


Dim strRecentPosts
strSQL = "SELECT TOP 10 topic_ID,subject from tblTopic ORDER BY Last_entry_date DESC"
rsCommon.open strSQL, adoCon
Do until rscommon.eof or rsCommon.bof
strRecentPosts = strRecentPosts + ("<a href=""http://www.yoursite/forum/forum_posts.asp?TID=" & RsCommon("topic_ID") & "&PN=1&TPN=1"">" & rsCommon("subject") & "</a><BR>")
rsCommon.movenext
loop
rsCommon.close

Then wherever you want the recent posts box simply put:


<%=strRecentPosts%>

Posted By: lodogg
Date Posted: 16 January 2004 at 1:44pm

Thanks that got me in the right direction... I need some more help but it's working now.

Thanks,

-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun