Quote:
Originally Posted by Dismounted
[sql]SELECT t.forumid
FROM post AS p
LEFT JOIN thread AS t USING (threadid)
WHERE p.postuserid = X[/sql]
PHP Code:
while ($post = $vbulletin->db->fetch_array($result))
{
++$posts["$post[forumid]"];
}
Did you actually look in the post/thread tables to see the relations?
|
Not as much as I could have. What is postuserid? Thanks.