I have a good puzzle. :) I have a table that looks like this:
User | Event | Score ------------------------------------ tom 1 2200 bill 1 1000 frank 1 2200 alex 1 2000 I would like to find an elegant way to produce: Rank | User | Score --------------------------------------- 1[Tie] Tom 2200 1[Tie] Frank 2200 2 Alex 2000 3 Bill 1000 I could do some really crazy thing where I loop through each line, but I bet there's a simple way to do it recursively. I'd hate for my lame hack to end up on http://www.thephpwtf.com/ :) Thanks, Jeromie The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
