[Logician]

Originally Posted by siddal

Firstly,
I?m trying to make a page with the last 30 threads showing forum-thread-user-date and succeeded. Almost.
The problem arises when I click on the forum name rather than the specific thread and I get
directed to the same forum (forum id7) every time. I?ve read through the posts on many versions of the mod and find nothing that resembles this. I should be grateful for any ideas/help.

SELECT thread.threadid AS threadid, thread.title AS title, thread.postusername AS postusername, thread.postuserid AS postuserid, thread.dateline AS dateline, forum.title AS ftitle, thread.forumid
FROM " . TABLE_PREFIX . "thread thread LEFT JOIN " . TABLE_PREFIX . "forum forum ON thread.forumid= forum.forumid 
WHERE thread.sticky=0 AND thread.visible=1
ORDER BY dateline DESC
LIMIT 30

and lastl but not least: thank you Logician for this.
It?s so versatile and such a lot of fun to play around with.

What's your query result row? If you use $WQfield[forumid] there, it should work fine.