[ic] Ranking System

[interchange-users@interchange.redhat.com (Jim Webster)]

I'm building a ranking system and wondering what the best way to go about
placing/adjusting members.  I'm using IC/MySQL.

Example:
Rank 1: Member_One
Rank 2: Member_Two
Rank 3: Member_Three
Rank 4: Member_Four

What I need the system to automatically do is adjust these ranks on the fly.
For instance, if Member_Three removes their account, I need Member_Four to
automatically move into Rank 3.  I also need to be able to allow new members
to join and automatically take the last "Rank #" which is somewhat undefined
as new members can join everyday.

I'd like this to possibly be in it's own table... is this possible and/or
does anyone have suggestions for me on how to go about accomplishing this?

Thanks.

Jim Webster