Last thread

[filburt1]

What query returns the forumid,threadid,and title for the most recent thread in each forum?

1. Yes, I looked at the code for TECK's hack
2. Yes, I tried this:
[sql]
SELECT t.title AS title, t.threadid AS threadid, f.forumid AS forumid
FROM thread t, forum f
WHERE t.forumid = f.forumid
GROUP BY f.forumid
ORDER BY dateline DESC
[/sql]
(it always returned the oldest one, not the most recent one)

[NTLDR]

Use ASC not DESC, seems to work for me

[filburt1]

Nope, still returns the first one.

[nuno]

Try

SELECT forum.*, thread.title as thtitle FROM forum
 LEFT OUTER JOIN thread on thread.forumid = forum.forumid and thread.lastpost >= 
(forum.lastpost-30)
 WHERE displayorder<>0 AND active=1
 ORDER BY parentid,displayorder

[filburt1]

That's TECK's

...but thanks, after changing his query a bit I got it to work.

[nuno]

Originally posted by filburt1
That's TECK's

No, it isn't