Web Wiz Forums - How many pages a topic has in the DB ?

Print Page | Close Window

How many pages a topic has in the DB ?

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=7395
Printed Date: 06 April 2026 at 10:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How many pages a topic has in the DB ?

Posted By: BarBar
Subject: How many pages a topic has in the DB ?
Date Posted: 19 November 2003 at 11:27am

Hi,
Where can I see how many pages a topic has ?
I am making "New in Forums" and I would like it will redirect to the last page...
Where can I find that in the DB ?

Many thanks,
Bar

Replies:

Posted By: michael
Date Posted: 19 November 2003 at 3:42pm

That information is not stored in the db like that so you either need to set up paging the way it is here and just use the max value or use a simple sql query like i.e.
Select (Count(tblThread.Thread_ID))/(tblConfiguration.Threads_per_p age)
From tblThread, tblConfiguration where tblThread.Topic_ID = 5
Group by tblConfiguration.Threads_per_page
to get the number of pages.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker