[Boofo]

Ok, this is definately the fix now. Apparently I have to do the AS part on all tables in a query that has more than 1 table. I never knew nthat before, so I guess we're both learning something here.

PHP Code:

    $topposter = $DB_site->query_first("
        SELECT user.userid, user.username, COUNT(post.postid) AS postcount
        FROM " . TABLE_PREFIX . "post AS post
        LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
        WHERE thread.forumid=$forumid
        GROUP BY post.userid
        ORDER BY postcount DESC
        LIMIT 1
    ");