Topic: Displaying and sorting users by most active rater

[Manne]

I've managed to get a list of all my (registered) users and how many ratings they have submitted by hacking the wp_list_authors function (in wp-includes/author-template.php) with the following code:

$q="select * from wp_ratings where rating_username='$name'";
$res=mysql_query($q);
$count = mysql_num_rows($res);


Now I'd like to sort the list by $count (ie by the number of times the have submitted a rating) to get an "Most active user top list". How would I do this in php?

[GaMerZ]

sorry I don't do custom mod (my sig)

[Ttech]

nor do I...