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
Quote:
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)