Display ??

[Bald Bouncer]

how do I display the amount of replies a user has made under a certain category?

[Admin]

This is the general query:
SELECT COUNT(postid) AS posts FROM post LEFT JOIN thread USING (threadid) WHERE thread.forumid='xx' AND post.userid='xx'
Where xx is the Forum ID, and xx is the User ID.

[Bald Bouncer]

Thanks for the fast reply :D

[Bald Bouncer]

oops sorry mate made a mistake the way I phrased it

I need to display the amount of replies a user has made under a certain catagory in there postbit

so i need it for me then one user, if possible

cheers

[Bald Bouncer]

lets try and simplify what Im saying

I need to show how many replies a user has made in a certain forum in their postbit (left of the post)

[Bald Bouncer]

can this not be done boys?