Try a JOIN:
PHP Code:
$info = $DB_site->query("
SELECT
thread.threadid as threadid,thread.title as title,thread.forumid as forumid,
thread.postusername as postusername,thread.postuserid as postuserid,thread.dateline as dateline,
thread.views as views,thread.replycount as replycount,forum.title as forumtitle
FROM thread AS thread
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid)
WHERE forumid IN($id)
ORDER BY threadid DESC
");