Web Wiz Forums - Database Help

Print Page | Close Window

Database Help

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=4279
Printed Date: 02 April 2026 at 6:36am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database Help

Posted By: robert_raw
Subject: Database Help
Date Posted: 16 July 2003 at 7:52am

After using the amazing Web wiz forums, my company has decided that i need to create our own forum.

I am using Dreamweaver MX, with a seperate table for new topics and replies, but i need to sort these into date order on the forum, so new topics are at top, and when replies are made, that topic is then moved to top.

I cant understand how it is done in WebWizforums.

Any help Would be appreciated

Replies:

Posted By: ljamal
Date Posted: 16 July 2003 at 8:00am

The replies table should have a date field that consists of the time the reply was added and the Topics table should have a date field that consists of the time topic was added as well as one that holds the most recent post to that topic.

The most recent post could also be found by running a seperate SQL query or creating a join with the reply table on the most recent posts per topic.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: robert_raw
Date Posted: 16 July 2003 at 8:06am

Hate to sound dumb, but how would i sort that in to an order in the page?

Posted By: ljamal
Date Posted: 16 July 2003 at 8:12am

Sort by the date in descending (desc) order.

If your field is called dtePosted then, the statement would end with:
order by dtePosted desc

If you do not have a full grasp of SQL, I would not recommend attempting to write a web forum.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming