Please help with a query

[romic]

Hi,

I have a table containing: clasifieds, userID

When I run the following query I get the number of Posts(clasifieds) by the user xxx

SELECT COUNT(userID) FROM clasifieds WHERE userID=$xxx

Now, I need a query that would return me the full list of users with the number of times each user has posted (number of clasifieds for each user) not only the user xxx, ordered(DESC) by the number of posts.

How do I do this?
Please help. Thanks.

[tomhath]

Untested:

SELECT userID, COUNT(*) FROM clasifieds
GROUP BY userID
ORDER by 2 DESC

If the ORDER BY doesn't work that way, check the manual of the DBMS you are using. I think that's standard SQL though.

[romic]

Thanks! It works.