Query for postcount of a post?

[superjeff]

Hi all, i'd like to make a query to take the postcount of a specific post having its id.
For example, this is the post 1536335 and knowing this i'd like to know the postcount in the thread.
Any ideas?

[Marco van Herwaarden]

Sorry i don't understand. The 'postcount' of a single post is always 1.

[superjeff]

I'd like to do a query that "replay" me 2 if, for exemple, i ask for post 1536862 (yours)

[Lynne]

So basically, given the postid, you want to find out how many posts are in the thread that contains that postid?

[superjeff]

No.. this is to easy
given the postid, i want to find out the postcount of the postid.

Thanks

[Lynne]

OK, I think I see. Your post above me is postid 1537117 and it has a postcount of 5 in this thread. Writing the query really depends on where you want to use this information because obviously it is already available to you in this thread.

[superjeff]

The only usefull variable cached are the postid and the threadid

[Marco van Herwaarden]

You would need to count the number of posts in the thread that have a dateline <= to the post you are looking for.