Top Thread Starter

Can someone please help me with a query that will pull the Top thread starter from a forum and the average threads that user has started in that forum? This is the only query I have left to do.

[Boofo]

The what would you use in place of the * in that query? Or is there a simpler and better way to do it?

[filburt1]

Just forum.whateveryouneed; for example: forum.title, forum.forumid.

[Boofo]

You mean like this?

$yourposts = $DB_site->query_first("SELECT forum.title, forum.forumid, COUNT(post.postid) as yourposts FROM forum, thread, post WHERE forum.forumid=thread.forumid AND thread.threadid=post.threadid AND post.userid='".$bbuserinfo[userid]."' AND forum.forumid='$forumid' GROUP BY forumid ORDER BY yourposts DESC LIMIT 1");

[filburt1]

Yes.

[Boofo]

So I don't need to declare the "forum.forumid as forumid" or the "forum.* as foruminfo"? And this will still give me the total post count for me in that forum (threads + replies)?