Another Query Question

[ChrisBaktis]

We have a custom profile field that contains the number of trades members on our site make...How do I get vBulletin to list out, lets say, the top 10 on one of our pages?

Also since we add these numbers manually is there a way to track the top members that recieve points in this field each month...not the total but only have many have been added from the first of the month to the end of the month?

[Marco van Herwaarden]

SELECT userid, fieldX from " . TABLE_PREFIX . "userfield
ORDER BY fieldX DESC
LIMIT 10
Something like that

If you didn't keep numbers for each month in database, then you can't get it out also.

[ChrisBaktis]

Any idea how i would show this in a template so the list appears on a page?