| Author |
 Topic  |
|
|
MxTxL
Starting Member
28 Posts |
 Posted - 11 May 2001 : 15:41:24
|
I posted this same question in Show-off your forum, but i think it's better suited here.
What would be a good set of criteria to judge how "HOT" a forum is at any one time. I'm working on a way for the default.asp page to just display the three "hottest" forums. I don't want to do it just based on number of posts.. because it may be that one forum just gets more posts than another.... what i'm looking to do is add a time element... like "This forum has had the most posts most recently"
What are the criteria for that, and how would i implement this statement (taken from the default.asp page) in that way:
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, "
strSql = strSql & strTablePrefix & "FORUM.F_STATUS, "
strSql = strSql & strTablePrefix & "FORUM.CAT_ID, "
strSql = strSql & strTablePrefix & "FORUM.F_SUBJECT, "
strSql = strSql & strTablePrefix & "FORUM.F_URL, "
strSql = strSql & strTablePrefix & "FORUM.F_DESCRIPTION, "
strSql = strSql & strTablePrefix & "FORUM.CAT_ID, "
strSql = strSql & strTablePrefix & "FORUM.F_TOPICS, "
strSql = strSql & strTablePrefix & "FORUM.F_COUNT, "
strSql = strSql & strTablePrefix & "FORUM.F_LAST_POST, "
strSql = strSql & strTablePrefix & "FORUM.F_STATUS, "
strSql = strSql & strTablePrefix & "FORUM.F_TYPE, "
strSql = strSql & strTablePrefix & "FORUM.F_PRIVATEFORUMS, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME "
strSql = strSql & "FROM " & strTablePrefix & "FORUM "
strSql = strSql & "LEFT JOIN " & strMemberTablePrefix & "MEMBERS ON "
strSql = strSql & strTablePrefix & "FORUM.F_LAST_POST_AUTHOR = "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rs("CAT_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "FORUM.F_SUBJECT ASC;"
If I were to go with number of posts I could just change the ORDER statement to "ORDER by FORUM.F_COUNT DESC" and just take the first three results.... but how could i do it with the different criteria like i have described above???
Does that make sense to everyone?? If not i will clarify.
Thanks
|
|
|
MxTxL
Starting Member
28 Posts |
Posted - 12 May 2001 : 15:30:02
|
Ideas, anyone? For now, i'm basing it on the number of topics then the number of posts...
IE: ORDER by FORUM.F_TOPICS desc, FORUM.F_COUNT desc;
|
 |
|
| |
Topic |
|
|
|
Topic Locked
