Salin,
The command you post is perfect for the second part of my problem and I will use it. Thank you. But still I have the first part: How can I re-count the number of posts that user has?
What's happen is 2 or 3 times a week I check all 'free' areas of my Forum, and delete those posts who are there only for add up the numbers in title.
There is more than one user, and more then one post. so will be hard to keep track of all.
I was thinking some bacth routine who gets all users, count all posts again, and give the correct titles to the users.
Too hard? I don't know nothing about MySQL
But I thank you for the command. That at least let me do it mannually for one expecific user, and if I can't find a better way, I will count posts mannually too.
