Easiest SQL to find the most recent reply - Posted (1347 Views)
Senior Member
Astralis
Posts: 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.<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Support Moderator
Shaggy
Posts: 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.”
Posted
Senior Member
Astralis
Posts: 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.<
Posted
Support Moderator
Shaggy
Posts: 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.”
 
You Must enter a message