Check this query please

[Logikos]

Ok this is what i placed

PHP Code:

        $info = $DB_site->query("
                SELECT
                        thread.threadid,thread.title,thread.forumid,thread.postusername,thread.postuserid,
                        thread.dateline,thread.views,thread.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
        "); 


And i get this

mysql error: Column: 'forumid' in where clause is ambiguous

mysql error number: 1052

Fixed it. Had to chage the WHERE statement to

PHP Code:

WHERE thread.forumid IN($id)