If you are planning to do that in postbits, it will be fairly server intensive.
Do you know how to use joins in MySQL?

I was hoping someone who is well versed in the db could just type out the query here. Yes, I know joins and such but I don't know the db that well.

Maybe have the output in the profile. Gives another member an idea where the person posts the most.

[sql]SELECT t.forumid
FROM post AS p
LEFT JOIN thread AS t USING (threadid)
WHERE p.postuserid = X[/sql]
Did you actually look in the post/thread tables to see the relations?

Not as much as I could have. What is postuserid? Thanks.

The creator of the post... postuserid

SELECT t.forumid
FROM post AS p
LEFT JOIN thread AS t
USING ( threadid )
WHERE p.postuserid =803

MySQL said:

#1054 - Unknown column 'p.postuserid' in 'where clause'

:confused:

--------------- Added [DATE]1235016809[/DATE] at [TIME]1235016809[/TIME] ---------------

Okay, I am really lost. How about if I have one forumid and one userid, how can I get the number of posts that user made in that forum? Thanks in advance.

I think I made a mistake, postuserid is for threads. Here is the "proper" query:
[sql]SELECT COUNT(p.postid) AS count
FROM post AS p
LEFT JOIN thread AS t USING (threadid)
WHERE p.userid = 803
AND t.forumid = X[/sql]

Gracias!