[Xenon]

damn, of course you're right
i had it in my mind, but forgot to write it down also...

also damn brackets

use this one:

PHP Code:

$forumposts = $DB_site->query_first("SELECT SUM(IF(thread.forumid IN (1, 2, 4, 6, 10), 1, 0)) as first, SUM(IF(thread.forumid IN (3, 5, 7, 8, 9), 1, 0)) as second FROM post LEFT JOIN thread USING(threadid) WHERE userid=$userinfo[userid]");