Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MSSQL Last 10 Posts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MSSQL Last 10 Posts
 Post Reply Post Reply Page  <123
Author
  Topic Search Topic Search  Topic Options Topic Options
bitbyter View Drop Down
Newbie
Newbie


Joined: 04 February 2007
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bitbyter Quote  Post ReplyReply Direct Link To This Post Posted: 04 February 2007 at 4:32pm
o.k it's a great mod MR Mellie.  thanks for it!   
 
i'd like to see in which (sub)forum the message is posted instead of seeing the beginning of the message . is there an easy way to change this?
 
 
istead of this
Topic Message Author Date Views
 
 
 
this
Topic Forum Author Date Views
 


Edited by bitbyter - 04 February 2007 at 4:38pm
Back to Top
PrivateEye View Drop Down
Groupie
Groupie
Avatar

Joined: 21 March 2003
Location: United Kingdom
Status: Offline
Points: 168 		Post Options Post Options   Thanks (0) Thanks(0)   Quote PrivateEye Quote  Post ReplyReply Direct Link To This Post Posted: 05 February 2007 at 8:48am
MR Mellie, I tried your code to get top 10 forum names only (not posts/topics in forums). But if users post 10 posts in one forum, this one forum is displayed 10 times. I am not good in SQL grouping, can you please help me and write the query to get true top 10 forum names. I will be thankful to you. I modified the SQL as

Select tblTopic.Subject, tblTopic.Topic_ID, tblForum.Forum_ID, tblForum.Forum_name, tblTopic.Last_Thread_ID, tblTopic.No_of_views
From tblTopic, tblForum
Where
tblTopic.Hide = 0 And tblTopic.Forum_ID = tblForum.Forum_ID
Order By tblTopic.Last_Thread_ID desc


Edited by PrivateEye - 05 February 2007 at 2:06pm
The Judgement Day
Back to Top
 Post Reply Post Reply Page  <123

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.