[bitwise2000]

Thank you, Lynne.

--------------- Added [DATE]1318538968[/DATE] at [TIME]1318538968[/TIME] ---------------

I understand a bit better what I'm trying to do, so let me restate.

I only want threads to be bumped by the OP in selected forums. Followups by others should not. We have a classifieds forum where many people comment on for-sale posts, which causes unnecessary bumping of the thread when the sort is Last Post Time. We still want to enable the OP to bump their own thread.

I envision two solutions;

(1) not update the lastpost field in the thread table when a post is made unless that post is made by the thread starter.

(2) Manipulate the query in forumdisplay that generates the recordset for thread display, substituting the time of last post by the OP for lastpost from the thread table. That requires a subquery into the post table for each threadid to be displayed.

As long as I'm willing to mess up the data integrity for a couple forums, this seems like the easier solution.

Anyone done something similar? Got a tip or two?