[Chris M]

I think your query is wrong...

I'm not sure if it is right, but try:

$attachs=$DB_site->query_first("SELECT forum.title AS forum, COUNT(attachment.attachmentid) AS count, SUM(LENGTH(attachment.filedata)) AS bytes
FROM attachment
LEFT JOIN post ON post.attachmentid=attachment.attachmentid,
LEFT JOIN thread ON thread.threadid=post.threadid,
LEFT JOIN forum ON forum.forumid=thread.forumid,
WHERE attachment.attachmentid = post.attachmentid 
AND post.threadid=thread.threadid 
AND forum.forumid=thread.forumid
GROUP BY thread.forumid 
ORDER BY count DESC");

Satan