Sort by newest Posting up top

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
luckyd Members Profile Find Members Posts Newbie Joined: 21 August 2003 Status: Offline Points: 1	Post Options Post Reply Quote luckyd Report Post Thanks(0) Quote Reply Topic: Sort by newest Posting up top Posted: 21 August 2003 at 5:02pm
	I'm running Web Wiz Forum 7.01 with a MS SQL database and wanted to know if there was a way to sort the latest postings within a topic to the very top instead of at the bottom. This way, when people log in, they see the latest posting for that topic. Thx. Dluk Edited by luckyd

shovel Members Profile Find Members Posts Groupie Joined: 08 November 2001 Location: United States Status: Offline Points: 72	Post Options Post Reply Quote shovel Report Post Thanks(0) Quote Reply Posted: 21 August 2003 at 5:58pm
	Hello Dluk, Approx line 267 in "forum_posts.asp" you'll find this: strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date ASC;" Change the "ASC" (ascending) to "DESC" (descending) --without the quotes--and that will change the order the posts display. Jim Edited by shovel

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.