Threads and posts
 

How can I find out the number of posts a user has made, but exclude posts that are the first post in a thread?

I would find the number of posts, then the number of threads but subtract the number of threads from the number of posts. That would exclude all first posts.

Amy

Possibly but would that be two queries?

Yep. Because I don't believe posts are normally marked as being the start of a thread unless you have installed certain hacks.

Amy

Nuts. Any other ideas?

maybe it's possible with one query, but it would mean you look at the thread and the post table within the same query, which would take time...

this is a thing where two queries are better than one

K, and I actually know how to code that. Thankies :)

I'd do it the same as amy :)

- miSt