[Kyomu]

Originally posted by FireFly
You are JOINing the forum table to itself without giving them an alias. That's the error, but in your code LEFT JOIN forum should be LEFT JOIN forumpermission.

Ah, thanks, it works now.
Now I'm getting a parse error here....

$threads=DB_site->query("SELECT threadid,forumid,dateline FROM thread WHERE $forumids ORDER BY dateline DESC");

Thanks for the help again.