MyBB Community Forums

Hey, I need some SQL help.

Basically, I need to be able to show a list of users that have specific criteria. For example:

I want to show the username of people and their post count in descending order via phpMyAdmin, it would work as:

USERNAME: ---- POSTNUM:
Jordan ------ 4
Bill ----- 3
Steve ----- 3
John --- 2

I hope that explains it enough. Any help would be great

SELECT username, postnum FROM mybb_users ORDER BY postnum DESC

That should do the trick.

Thanks a ton, Paul.