Forum stuff - I dont know either

Ello dudes,

Thanks again for the help with the sub-routine stuff.

Anyway today someone asked me how does the forum get thread info like
# of replies, # of views, who last posted & the time

Yea we all know is coming from the database.

eg. strSql ="SELECT status, categoryid, forum_id, topic_id, view_count, subject, "
strSql = strSql & "author, sticky, replies, ureplies, lastpost, lastpost_author, "
strSql = strSql & "lastpost_replyid, M_NAME, 1.M_NAME AS lastpost_author_name "

If it was like ths it would mean all the info is added to the database and all replies, views would be stored.

Hey i'm grabbing at straws here, the people who know what

help!!!!!





---------------------------------------------------------------------
Knowledge is power - send some please
--------------------------------------------------------------------

Yes... you're correct...
The number of views can be a column at the message table. The number of threads can be checked by using SELECT COUNT(*) AS threadsNumber FROM table WHERE reply_to_message_id LIKE 'id_of_the_original_message'
But I think that it uses multiple queries...

Thanks dude,

I guess my mumble jumble was on the right path.

Anyone have working forum can lend a hand on the design aspect just for guidance purposes.


Much appreciated.


--------------------------------------------------------------
War Sucks!!!! -- Kruzien2002
--------------------------------------------------------------