Easiest SQL to find the most recent reply

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/66921?pagenum=1
05 November 2025, 19:38

Topic


Astralis
Easiest SQL to find the most recent reply
24 April 2008, 04:26


I am listing the top ten newest updated articles and want to point a user to the most recent reply when they click on the link.

Does anyone know the simplest method to do this?
Thanks in advance.<

 

Replies ...


Shaggy
24 April 2008, 04:31


If you're using v3.4.06, just add whichpage=-1 to the querystring:

topic.asp?TOPIC_ID=[ID]&whichpage=-1
<
Astralis
24 April 2008, 05:10


Shaggy,

I know I have at least .05 + patches. I think the patches brought me up to .06. I can't check yet, but is it simple to tell me what would make that work? I tried it on one of my urls and it had no reaction.<
Shaggy
24 April 2008, 05:14


Here's the code. You'll need to jump back to the first page to see where it goes.
<
© 2000-2021 Snitz™ Communications