Easiest SQL to find the most recent reply - نوشته شده در (1348 Views)
Senior Member
Astralis
مطلب: 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.<
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
نوشته شده در
Senior Member
Astralis
مطلب: 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.<
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
 
شما باید یک متن وارد کنید