Change forum ID "Where" location in PHP!

[MarkFoster]

Originally Posted by Carnage-

PHP Code:

$threads = $vbulletin->db->query_read("
    SELECT thread.threadid, thread.title, thread.iconid, thread.dateline, thread.postusername, thread.postuserid,
        post.pagetext
    FROM " . TABLE_PREFIX . "thread AS thread
    INNER JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
    WHERE thread.forumid = <number>
    ORDER BY thread.dateline DESC
    LIMIT 5 "); 


the above code is slightly misleading; so i posted you the whole query. replace <number> with the forum id you want

That's odd, when I add your code the entire page I use the module on breaks, however if I turn it back to what it was before then it works fine.