Easiest SQL to find the most recent reply - Postet den (1349 Views)
Senior Member
Astralis
Innlegg: 1218
1218
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.<
   
 Sidestørrelse 
Postet den
Support Moderator
Shaggy
Innlegg: 6780
6780
If you're using v3.4.06, just add whichpage=-1 to the querystring:

topic.asp?TOPIC_ID=[ID]&whichpage=-1
<
Search is your friend “I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Postet den
Senior Member
Astralis
Innlegg: 1218
1218
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.<
Postet den
Support Moderator
Shaggy
Innlegg: 6780
6780
Here's the code. You'll need to jump back to the first page to see where it goes.
<
Search is your friend “I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
 
Du må legge inn en melding