How many pages a topic has in the DB ?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BarBar Members Profile Find Members Posts Newbie Joined: 18 November 2003 Status: Offline Points: 16	Post Options Post Reply Quote BarBar Report Post Thanks(0) Quote Reply Topic: How many pages a topic has in the DB ? 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

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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.
	Blog \| MPG Tracker

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.