[LizerisCHN]

Originally Posted by Live Wire

Theres a slight bug it seems. When i place this code.

PHP Code:

$getthreads = $DB_site->query("
        SELECT threadid,title,dateline
        FROM " . TABLE_PREFIX ."thread
        WHERE postuserid = '$userinfo[userid]' AND forumid IN ('27,28,29,30,31,32,11,5')
        ORDER BY dateline DESC
"); 


It only shows the threads in ID 27. Which is the first on the list. It doesn't grab the rest. Any reason why?

Your code would need to look like this:

PHP Code:

$getthreads = $DB_site->query("
        SELECT threadid,title,dateline
        FROM " . TABLE_PREFIX ."thread
        WHERE postuserid = '$userinfo[userid]' AND forumid IN ('27','28','29','30','31','32','11','5')
        ORDER BY dateline DESC
"); 


It needs to define each forumid separately.