Codezwiz >> Forums >> General PHP Nuke Help >> SQL Relative Rank Question for Ranking Module

I have created a module to rank unsigned bands based on total song plays from my web site. I am having a problem resolving the relative rank (based on total plays) from my artist database.

This is the SQL I use to get the totals, which works fine:

SELECT SUM( hifi_scount_total + lofi_scount_total ) AS count FROM {$jamroom_db['scounter']} WHERE band_id=10

What I want to do is determine the RANK of "band_id=10" relative to the other bands. Since each band ID has multiple songs, I will need to use the group function, but have thusfar been unsuccessful.

Ultimately, I want my output to look like:
Currently "artistname" is ranked "x" out of "y" artists.

If anyone can shed some light, I would be MOST greatful!!!!
minusme