Most Active Posts...

Results 1 to 2 of 2

Thread: Most Active Posts...

  1. #1
    Join Date
    Dec 1969

    Default Most Active Posts...

    I am building a message board and I want to retrieve the most active posts, similar to this:<BR><BR>topic 1 (45)<BR>topic 2 (34)<BR>topic 3 (25)<BR><BR>I have numerous categories(30) and each categories has a series of posts.<BR><BR>I am wondering if this is the best methodology to do this:<BR><BR>1) query each category using COUNT to get the number of posts.<BR>2) Order the posts COUNTs from highest to lowest<BR>3) Select the top 3 results from the #2 and publish.<BR><BR>Is this the right direction? Is there a better way to do this? <BR><BR>Thx<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default select from the table

    use TOP to get the most whatever order by DESC the kep part will be GROUP BY parent post id column<BR><BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts