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.
Code:
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.