SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP It would need joining to the users table to get the username etc etc but that's the general idea.